M/o/M Month over Month expression

[Jeramie_Hieb]

I have a weekly reports table with columns for:

• This Week’s Revenue
• Month to Date Revenue
• M/o/M (Month over Month) Change/Pace
• Year to Date

I need help figuring out the best way to create a Month over Month comparison expression.

[Suvrutt_Gurjar]

Welcome to the AppSheet community.

You will be able to build the required expressions from the AppSheet functions. AppSheet has a rich set of date, month, week related functions. The related help articles share many examples of the calculation of dates based on those functions. Please do take a look at these functions / sample apps, searchable by keywords at https://www.appsheet.com/Support

https://www.appsheet.com/Support?q=week&hPP=10&idx=help&p=0&is_v=1

https://www.appsheet.com/Support?q=month&hPP=10&idx=help&p=0&is_v=1

[Jeramie_Hieb]

It’s not as precise as I am looking for as I wish I could calculate based on the exact number of days in each month, but this is what I came up with:

(([Projected Rev MTD]/[Days so far]*30.5)-[Projected Rev Prior Month])/[Projected Rev Prior Month]

Columns in expression:

[Projected Rev MTD]
SUM(SELECT(EOW Reports[Revenue Projection],
[Year - Month]=[_ThisRow].[Year - Month]))

[Days so far]
DAY([To])

[Projected Rev Prior Month] - SUM(SELECT(EOW Reports[Revenue Projection],
[Year - Month]=[_ThisRow].[Prior Month]))

The result is a percentage of Pace/Change Month over Month