Subtract and round number

[M_SBS_6]

Hi, 

I have a measure where I subtract 2 values

Difference=comp_val - app_val.

Comp_Val has these values 5,866.610000000010000

6,545.120000000000000

App_Val has a value of 

5,866.610000000000000

6,545.119999999999000

So my difference is showing as 

0.000000000000000909

0.000000000000001819

I really don't need to go into this detail. Ideally I'd like the difference cal to be rounded to the nearest 2 decimal place. 

Any idea how to go about doing this please? 

[Thejeswar · Accepted solution]

Hi @M_SBS_6 ,

You need to modify the Difference measure as shown below

Difference = ROUND(comp_val - app_val, 2)

You can also get this from ribbon by selecting on the measure and setting the no of decimal places