Skip to Content
0
Former Member
Feb 09, 2015 at 11:12 PM

Sum of Amount based on filter on other field

19 Views

I am trying to create a report where sum of amount would be displayed in 3 different columns based on what is in EDLCode field.

So,

If EDLCode IN (501,502,503) Then Sum(Amount) in Column1

If EDLCode IN (505,506) Then Sum(Amount) in Column2

If EDLCode IN (1500) Then Sum(Amount) in Column3

Let me know if this makes sense. I am getting the report to work when I put fields in detail section but I need only one line per employee, so I am using Group Header and it shows 0 in column 2 and 3.

Final data should look like:

EmployeeName Column1 Column2 Column3

My ultimate aim is to concatenate all this fields in 1 field and be able to send as fixed width file.