Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
shirleyc40
Creator
Creator

Value list dimension for multi kpi, change formatting

Hi. 

I have a multi kpi and I'm using a value list for the dimension. In the measures, I have specific calculations for each valuelist item, but I was wondering if it is possible to set a different format pattern for one of them because I have a ratio field that is 0.56 but it rounds to 1.

Labels (1)
1 Solution

Accepted Solutions
arulsettu
Master III
Master III

8 Replies
arulsettu
Master III
Master III

Use num function on your every measure based on you need for example

num(Sum(expression),'#.##') = 1234.56

shirleyc40
Creator
Creator
Author

What would be the formatting for 0.56? 

arulsettu
Master III
Master III

Try the above

shirleyc40
Creator
Creator
Author

Not sure why in the multi kpi it still rounds to 1, but if i display it separately it is the decimal

arulsettu
Master III
Master III

Can you provide sample app

shirleyc40
Creator
Creator
Author

I have created some sample data

arulsettu
Master III
Master III

Check this

shirleyc40
Creator
Creator
Author

Not sure why it doesn't work in my actual app but since it works in the example, it might help other people. Thank you, I'll try exploring