Forum Discussion
Month over month change wrong values
Hello,
Can someone explain why MOM% gives inappropriate values? It doesn't matter whether it is from QuickMeasures or my one
Current Month - 76% [4559/5975]
Last Month - 54% [3267/6089]
It looks like its something like 41~ if we do (76-54)/54, however both Quick Measure and my measure shows 42%. Could decimal places play role in that too? Unfortunately I can't share the data, only the measures I am calculating it with, if necessary
Pbiuserr , I checked out, Your 76% and 54% assumption is wrong. If you need that use round on formula and make it 0 decimal place
I tried this
(4559/5975-3267/6089)/(3267/6089)and give the same result 42.20
5 Replies
amitchandak
It shows 42,21%EDIT: well it works when on 3 decimal places. Can you do something around it? so on first glance it doesn't look incorrect ?
Pbiuserr , I checked out, Your 76% and 54% assumption is wrong. If you need that use round on formula and make it 0 decimal place
I tried this
(4559/5975-3267/6089)/(3267/6089)and give the same result 42.20
