I have a report that shows this:
electronics 2 8
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?