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!