Forum Discussion

nleuck_101's avatar
nleuck_101
Icon for Continued Contributor rankContinued Contributor
3 years ago
Solved

% Change number not calculated correctly, maybe rounding?

Hello All,   I could use some help with calculating Month over Month % change. Below are my formulas I'm using and results I'm getting. Any help would be greatly appreciated!   Measure 1 (1st col...
Need Help
  • HotChilli's avatar
    HotChilli
    3 years ago

    Looks like you will have to ROUND the measures when you use them in measure3

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
3 years ago

8.32% is 58 (more or less) so yes, I suspect that the real figures are not 756 or 697 exactly.  There will be decimals in there which are not shown in the display but will be used in the measure formula.

That's my theory.  You can prove it by formatting the measures to show a few decimal places.