Simple IF condition in expression

[gfisch13]

Hi Folks....I thought this expression was simple but it keeps throwing an error, what am I doing wrong??

=IF([CASE_STATUS] = "Closed-Fraud", COUNT[CASE_NUMBER])

Thanks, George

[Nicole-Smith · Accepted solution]

You're missing a few parentheses:

=IF([CASE_STATUS] = "Closed-Fraud", COUNT([CASE_NUMBER]))

I would also suggest using set analysis instead of an if statement:

COUNT({<[CASE_STATUS] = {'Closed-Fraud'}>} [CASE_NUMBER])

[gfisch13]

Thank you!!  Forgot the syntax for set analysis, appreciate the help!