AnsweredAssumed Answered

Conditional Sum

Question asked by carla.campomanes on May 3, 2018
Latest reply on May 3, 2018 by carla.campomanes

Hey guys, what would be the calculation for a conditional summary field that I can use on sub-summary parts?

 

I want to get summary of totals of invoices paid in EURO and another field for summary of totals paid in RSD - these fields I want to put on the sub-summary part of my layout. I need 2 separate fields for this for my trailing grand summary part. An easy fix solution I did is I added a sub-summary part when sorted by currency, but I'm facing problems because it's calculating everything (EURO and RSD) as one field for the trailing grand summary part.

 

I have a currency field and an amount field.

 

Any inputs will be greatly appreciated as always!

Outcomes