asked on May 21, 2022
Hi,
Would like a calculated measure which effectively displays the difference in the ** displayed values on the grid** after formatting (e.g. to 0 decimal places) is taken into account.
For example, it may show 95% if it's 95.49% and 96% if it's 95.51%
in this case, i would want the calculated measure to show 1%. since the displayed values are 1% apart.
how can i create a measure that calculates using the displayed measures with formatting?
Thank you,
Stay safe.
⋅ May 23, 2022
Hello, Michael!
Thank you for your question.
Kindly note that you can achieve the desired behavior by applying round function to unformatted values in the calculation value formula.
Please don't forget about specifying aggregation inside the round function.
We have prepared a JSFiddle example with average aggregation for visualization: https://jsfiddle.net/flexmonster/zk2vr6hy/.
Hope it helps. Feel free to contact us in case of any other questions.
Regards,
Solomiia
⋅ May 30, 2022
Hello, Michael!
Hope you are having a great week.
Just checking in to ask if you had a chance to try the suggested approach using the round() function to calculate the difference. Could you let us know if it was helpful?
Looking forward to hearing from you.
Regards,
Solomiia
⋅ June 6, 2022
Hello, Michael!
Hope you are having a great week.
Just checking in to ask if the suggested approach of calculating the difference was helpful for your case.
Looking forward to hearing from you.
Regards,
Solomiia
