Sum a column based on the values in another column

[tlucyk]

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?

[tlucyk · Accepted solution]

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)))