Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Check this
Use num function on your every measure based on you need for example
num(Sum(expression),'#.##') = 1234.56
What would be the formatting for 0.56?
Try the above
Not sure why in the multi kpi it still rounds to 1, but if i display it separately it is the decimal
Can you provide sample app
I have created some sample data
Check this
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