Help me - summing question

system · January 4, 2005, 4:49pm

This is driving me nuts! I want to do something like sum(if(level =“4-cce” or level = “3-abe” )then 1) however, I don’t want the field level on my report. I tried doing a where and that will work if I only use one critera. sum(id where level = 4) how do I do an or??? THis is nuts!

lula123 (BOB member since 2004-04-13)

system · January 4, 2005, 5:21pm

Please, tak a look at this FAQ Reporter entry.

Andreas (BOB member since 2002-06-20)

system · January 4, 2005, 9:20pm

Can you do something like:

sum(id where level = 4)+sum(id where level = 3)

csurguine (BOB member since 2005-01-04)