This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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.
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] C...