Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I am trying to sum values based on the GL Account for multiple rows. Similar to the below:
Name | Gross Amount | GL Account |
Joe | 1000 | 408000 |
Betty | 1500 | 408005 |
Frank | 12000 | 577209 |
Louisa | 5022 | 408000 |
John | 4545 | 408008 |
Cathy | 5868 | 408004 |
So basically I want to sum the Gross Amount, but only for GL Accounts '408000', '408004', '408005', and '408008'. So I don't want to include '577209'.
So my column should display a total of 17,935.
Could you help me write a function to capture the appropriate data?
I figured this out. Including the below for anyone else having the same issue:
Sum({<GL Account={'408000','408004','408005','408008'}>} num(trim(Gross Amount)))
I figured this out. Including the below for anyone else having the same issue:
Sum({<GL Account={'408000','408004','408005','408008'}>} num(trim(Gross Amount)))