Forum Discussion

anglefbi11's avatar
anglefbi11
Helper I
1 year ago
Solved

issue with measure calculation

hi dears i created a measure to calculate the difference between 2 numbers   the issue that it gave me some wrong percentage   some of them are giving me the correct answer and some of the is sh...
Need Help
  • rsbin's avatar
    rsbin
    1 year ago

    anglefbi11 ,

    Believe your issue is a rounding issue.  Your value of 162 is probably closer to 161.65.  You are simply displaying a rounded value.  To test this, display two decimal places in your [abc] measure in your visual.
    You can fix this by using the ROUND function in your [abc] measure.  This should round up the result to 162 which will give the percentage you are looking for.

    Hope this resolves your issue.

    Regards,

rsbin's avatar
rsbin
Community Champion
1 year ago

anglefbi11 ,

Believe your issue is a rounding issue.  Your value of 162 is probably closer to 161.65.  You are simply displaying a rounded value.  To test this, display two decimal places in your [abc] measure in your visual.
You can fix this by using the ROUND function in your [abc] measure.  This should round up the result to 162 which will give the percentage you are looking for.

Hope this resolves your issue.

Regards,