Ticket #30142
Question
How can I create a variance calculation that look specifically at the prior and current columns when I'm comparing dates in a Period Analysis report? Example: (Current period) Revenue minus (Prior period) Revenue.
Answer
Informed customer he can do this via an m-Painter calculation. https://www.mrc-productivity.com/docs/m-painter-app-prop/using-the-run-time-calculator. Assuming his field is named 'REVENUE', his calculation expression should look like similar to this: ${subTotal1.REVENUE_C_o}- ${subTotal1.REVENUE_P_o}
Asked on March 19, 2020