Forum Discussion

HenrikH29's avatar
HenrikH29
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Show values as whole thousands

Is there a way to format visuals or tables to have the numbers shown in whole thousands.   The object is to make it more readable ie. "1.234" instead of "1.234.123" as i have a large number of valu...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Ahh for a matrix, got ya.  For those i believe you'd have to write a measure that would convert the output for you.

     

    Maybe something like:

    Your Measure = ([Your Value] / 1000) & "K"

    You could add rounding in here too.

     

HenrikH29's avatar
HenrikH29
Icon for Advocate I rankAdvocate I
9 years ago

Yes that was what i was "afraid of" .

 

I have a lot of values so i had hoped for a easier solution :-)

 

Perhaps it will come as an option later...

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I just tested this on a file i'm working on thats fairly sizable.  This was pretty fast:

Rev = 
VAR
	Result = round([Revenue] / 1000, 0)
RETURN

if(
	Result = 0,
	BLANK(),
	Result & "K"
)

*Note [Revenue] is a measure i'm using that is a sum of data.