AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
Forums
AUG Forums
Acumatica Report De...
Sum iff total amoun...
 
Notifications
Clear all

Questions Sum iff total amount

 
Acumatica Report Designer
Last Post by Teckla Kapuenene 4 years ago
1 Posts
1 Users
1 Reactions
1,319 Views
RSS
Teckla Kapuenene
Posts: 14
 Teckla Kapuenene
Topic starter
April 12, 2022 8:15 pm
(@teckla-kapuenene)
Eminent Member
Joined: 5 years ago

Hi Everyone

I checked on forum to gather more information on the my issue but i dont seem to find the solution

my column show the total interest per different codes. but i only want to look at the total of 2 codes

my column fomula is

=IIf([LMTransactionCode.TranCodeCD]='100',[LMTran.BaseTranAmount],
IIf([LMTransactionCode.TranCodeCD]='101',[LMTran.BaseTranAmount] ,'0,00')) and this is working perfertly fine

and to get the total i tried

=Sum (IIf([LMTransactionCode.TranCodeCD]='100',[LMTran.BaseTranAmount],
IIf([LMTransactionCode.TranCodeCD]='101',[LMTran.BaseTranAmount] ,'0,00')))

=IIf([LMTransactionCode.TranCodeCD]='100','101',sum([LMTran.BaseTranAmount]),'0,00')

and they are not working

what is the best approach to resolve this issue?

Please assist

 


Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 32 Online
  • 2,438 Members
Our newest member: Ralph Torres
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×