I am setting a P&L that shows month over prior month. I would like to add a column that shows the amount variance and % variance. What is the syntax needed in the calculation formula to do the math to subtract one column from another?
Solved
How do I add a variance column in a column set for a P&L report?
Best answer by Laura03
Hello,
This example is from Acumatica’s pre-defined Column Set:
(B - C) is column subtraction, Current year minus Last Year (your question)
(B - C)/B is the Change presented as Percent change over last year.
+20Hello,
This example is from Acumatica’s pre-defined Column Set:
(B - C) is column subtraction, Current year minus Last Year (your question)
(B - C)/B is the Change presented as Percent change over last year.
Thank you! I had tried that but it looks like I missed changing the Type at the top from GL to Calc and that was in fact causing it to not work.
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.