I have a column called group number. We have several group numbers. Too many to list in a cast statement.
I have one column where I want to sum all group numbers in my Business Intelligence Software.
I used the following logic when I wanted sum just a few group numbers. I create what software calls a calculated field, and then I formatted it for SUM. This one works:
when NATIONAL_ACCOUNTS.group_nbr in ('03','04','04FT','05','05FT','05FT2','08','08FT','12','07')
Now I want to do the same thing for any group number (too many to list). I used the same logic, but changed it a little. It does not work. When I format the Calculated field to SUM, it shows 0:
when NATIONAL_ACCOUNTS.group_nbr in '*'