Calculate % Increase from previous month

[stuartfrew]

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%

[Anil_Babu_Samineni]

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)