Solved

ARM not consistent with formula set

  • 24 January 2024
  • 1 reply
  • 25 views
J
Rank

Hi, I’m trying to do a PNL report with actual vs budget with variance amt and % columns. I have set the formula in the column set like this:

 

However, the result doesn’t seem to be consistent. Like this highlighted value:

 

The result doesn’t seem to match with the formula I have set. In fact, I’m confused about how it arrived at that amount. But the one in the 3rd row is correct. There seems to be inconsistency. Does anybody knows about this?

icon

Best answer by Laura02 24 January 2024, 12:13

View original

1 reply

Laura02
Rank
Badge +18

Hello,

One thing to try, when ARM calculations are unexpected, is changing the Cell Evaluation Order.

Change Cell Evaluation Order to the opposite value

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved