Sum if - what's wrong with my expression?

[#1]

Hello

I was wondering what's wrong with my expression?

sum(if([Tariff range]='No tariff',({<[Application Status]={'C/F','U/F'}>} [FTE dashboard])))

There is an error and I am pretty sure it's something to do with the [Application Status]....'U/F bit,, as it is work fine without this part i.e. sum(if([Tariff range]='No tariff',[Stprog Count FTE])).

Any ideas?

Thanks

Ewa

[andrespa]

Hi Ewa, try:

if([Tariff range]='No tariff', sum({<[Application Status]={'C/F','U/F'}>} [FTE dashboard]))

[swuehl · Accepted solution]

Try

sum({<[Application Status]={'C/F','U/F'}>} if([Tariff range]='No tariff',[FTE dashboard]))

or

sum({<[Application Status]={'C/F','U/F'}, [Tariff range] = {'No tariff'}>}[FTE dashboard])

[Aurelien_Martinez]

Hi Ewa,

sum({<[Application Status]={'C/F','U/F'}, [Tariff range]={'No tariff'}>} [FTE dashboard])

Aurélien

[luis2793]

Hello Ewa.

Please try with this expression:

if([Tariff range]='No tariff',sum({<[Application Status]={'C/F','U/F'}>} [FTE dashboard]))

[#6]

Thanks Andres, unfortunately this suggestion did not work for me.

[#7]

Swuehl

Thanks very much, the first suggestion solved the problem, brilliant!

[oknotsen]

If your question is now answered, please flag the Correct Answer.

If not, please make clear with which part of this topic you still like to get help .