Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to calculate a measure Where I am need sum(A)-Sum(B). In this Instance Both the Values are same that is Sum(A)=Sum(B).
But When I Create a KPI to show Sum(A)-Sum(B) I am getting value of 0.06n. Please help in this regard.
Thanks
Hari
There might be minor difference in decimal values of the A and B.
If you convert it to Interger or Decimal till 2 Values it will show as zero.
Try to round up values using Round().
For ex.
Round(86.656982, 0.01)
It will round up value till 2 decimal
Thank you Shraddha for you suggesstion.