Get Free Trial

how to calculate difference of cells displayed on grid with format taken into consideration

Answered
Michael T 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.

3 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster 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

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster 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

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster 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

Please login or Register to Submit Answer