We have a P&L report in Acumatica where we have a column that calculates the percent of budget used. This column works for all lines except totals that add/subtract more than one line. The only reason I could suspect this is happening is because the system runs the line calculation after the column? I’m not entirely sure. I have tried creating an additional line that points at the total line but unfortunately it still does not calculate. Any thoughts?
Solved
ARM Report Column Calculation not applying to Total Rows
Best answer by Laura02
Hello, Try changing the Cell Evaluation order in the Column Set for your report.
Hi Acumatica,
Hope this concern has an answer. I am having issues computing percentage if the row is set as total..
Thank you..
1 person likes this
+19Hello, Try changing the Cell Evaluation order in the Column Set for your report.
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
Thanks for the answer! Its honestly been so long, I don’t remember what we did to resolve that issue. We probably found a workaround or just went about it a different way. Good to know there is an answer out there!
1 person likes this
Hi, I tried the solution from Laura01 but I am getting an error message. There is nothing in the Trace to help me. I have this formula in the column value: =iif(B=0,0,B/Value(@BaseRowCode, 'B')). Has anyone used the Cell evaluation order = Column with the @baserowcode? Thanks,
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.