Format measure in 000's


  • I've been trying to figure out a way of displaying a measure I have - sum of households - in 000's i.e. instead of 4,012,000 I want to display 4,012.00 . I know I can do it as a calculation but is there any way to just format the measure itself and instead of measure being a simply sum(x) or distinct count(x) it's sum(x)/1000 or COUNT(Distinct x)/1000?
    Friday, August 10, 2012 3:15 PM


All replies

  • Hi Rathlin,

    Use  "#,#," as the format and it will show in Thousands.


    Shahfaisal Muhammed

    Friday, August 10, 2012 4:16 PM
  • I probably didn't explain that very well. I want to show the number rounded to the nearest thousand - instead of 4,012,000 I want to display 4,012.00
    Thursday, August 23, 2012 3:36 PM