topic Calculate % Increase from previous month in App Development

Calculate % Increase from previous month

stuartfrew — Tue, 04 Dec 2018 12:46:24 GMT

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%

Re: Calculate % Increase from previous month

Anil_Babu_Samineni — Tue, 04 Dec 2018 13:14:27 GMT

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)

Round(([This Month Formula]-[Last month Formula])/[Last month Formula]*100,0.01)