Skip to main content
Question

how to display total, value column by formula IIF?

  • February 10, 2025
  • 4 replies
  • 52 views
snapitupulu55
Freshman I

i am trying to setup Total row in ARM, after set formula in column. 

How do I display the total that I have created in the row set? I was asked to create a Trial Balance with an ending balance of Debit and Credit, as a result the column uses a fairly long formula. My guess is that because of the formula, the total row set cannot display the sum. or maybe because I am using a subaccount 

Row Set

 

the total row set cannot display the sum.

 

Thank you,

Jefri

4 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • nhatnghetinh
  • Captain II
  • 523 replies
  • February 10, 2025

Hi ​@snapitupulu55 

The total in the Row Sets is simply the sum of the rows that you want to sum.
Your problem may be because the formula to retrieve data for columns in Column Sets is not correct.

 

 

Best Regards,

NNT

I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/truongpham80
Chris Hackett
snapitupulu55
2 people like this
  • Chris Hackett
    Chris Hackett
  • snapitupulu55
    snapitupulu55
dcomerford
Captain II
Forum|alt.badge.img+15
  • dcomerford
  • Captain II
  • 636 replies
  • February 10, 2025

​@snapitupulu55 Agree with ​@nhatnghetinh Would suggest to trouble shoot start with a simple formula of just two rows and then keep adding to it

Dermot Comerford
Chris Hackett
snapitupulu55
2 people like this
  • Chris Hackett
    Chris Hackett
  • snapitupulu55
    snapitupulu55
snapitupulu55
Freshman I
  • snapitupulu55
  • Author
  • Freshman I
  • 1 reply
  • February 11, 2025

Thank you ​@nhatnghetinh I'm still having trouble making a simple example, because with a simple scenario there is no problem, the total row appears.

nhatnghetinh
Captain II
Forum|alt.badge.img+11
  • nhatnghetinh
  • Captain II
  • 523 replies
  • February 11, 2025

Hi ​@snapitupulu55 

Please attach your ARM report and some screenshots describing the problem you are having.

 

Best Regards,

NNT

I have devoted my time and deep passion to Acumatica! 🌐 https://www.linkedin.com/in/truongpham80
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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