Vizlib Home Try Vizlib
Welcome
Login

Question about formatting KPI Value based on a dynamic Measure

I have a dynamic measure. Depending on the value selected in a field the resulting KPI could bae a huge number (Billions) a small number or a percentage.


I have tried auto, but then you will see decimals for small numbers (like 4.0) and that is not what we want.


I think I could make percentage work if the number is less than 1, but I struggle with with getting it to show 

35.1k in one situation and 31 if you filter farther down. I see 31.0 instead.


I have tried not formatting the value as a number and that might work, but I will have to clean up the decimal places on the way in and because this is dynamic that actually ends up being a lot of work. 

In this example you can see that if I use "Auto Number" format anything below 100 gets the two decimal places.

image


If I use the custom I can get the percent I want and lose the two decimal points, but I can never get the (k,m,b) instead of the full number.

image


I am probably making this more complex than it needs to be. Any assistance is appreciated.



qvf
Login to post a comment