AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
Using a formula to ...
 
Notifications
Clear all

Questions Using a formula to flip signs in Row Set In the Column Set, there is a Calculated Column

 
Acumatica Report Designer
Last Post by Michael Peck 3 years ago
2 Posts
1 Users
1 Reactions
1,093 Views
RSS
Michael Peck
Posts: 26
 Michael Peck
Topic starter
April 27, 2022 12:30 pm
(@michael-peck)
Trusted Member
Joined: 4 years ago

ARM Row set uses a formula to flip the signs of Liability and Revenue range accounts.

In the Column Set, there is a Calculated Column which works for all accounts except those where the sign was flipped. These all come up blank.

Is there something needed to include these accounts in the Column Calculation?


1 Reply
Michael Peck
Posts: 26
 Michael Peck
Topic starter
April 27, 2022 4:09 pm
(@michael-peck)
Trusted Member
Joined: 4 years ago

 See the included screenshot of the relevant line from the Row Set, and the resulting of the Liability Account lines in the generated Report output.

Case 000157 Row and Report Samples .docx

Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 24 Online
  • 2,338 Members
Our newest member: Shoaib Shafquat
Latest Post: Pick List report suddenly not splitting on Shipment
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×