Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I would like to cal the % increase/decrease from a previous month? the answer I want to get to is 11.89% in this example
Last month - 5610
This month - 6277
# CHange - 667
% Change = 11.89%
Try this?
=Round((Sum({<Month={"$(=Max(Month))"}>} Sales)-Sum({<Month={"$(=AddMonths(Max(Month),-1))"}>} Sales))/Sum({<Month={"$(=AddMonths(Max(Month),-1))"}>} Sales)*100,0.01)
Or
Round(([This Month Formula]-[Last month Formula])/[Last month Formula]*100,0.01)