Skip to Content
0
Jan 12, 2016 at 04:16 PM

sum where inlist help....

32 Views

Hello,

I have a report that shows this:

dept no

electronics 10

electronics 2 8

beauty 8

clothing 9

clothing II 5

I need to group by dept.

I made a variable =Sum ([no]) where ([dept]) InList ("electronics"; "electronics 2"))

This works fine.

The problem I am facing is that electronics/electronics 2 may not be there in every report. So the report hangs and hangs..

How do I fix?

Thanks

Chuck