Error in a formula code

[janus2021]

Hi.

Someone who can see where I typed the code incorrectly. receives error message in Qlik is: 'Error in expression: ')' expected'

what is wrong whit this?
If(sum({<[Month]=>}[EmplF]={'On'})>'0',sum({<[Month]=>}{<[LeaveC]=>}[Nrb_Empl_Leav])/
sum({<[Month]=>}[EmplF]={'On'}, {<[LeaveC]=>}[Nrb_Empl]/12),0)

This is working
If(sum({<[Month]=>}[Nrb_Empl])>='10',sum({<[Month]=>}[Time_S)/sum({<[Month]=>}[Tot_Empl_T]),0)

Regards

Janus

[rubenmarin · Accepted solution]

Hi, this syntax is wrong: sum({<[Month]=>}[EmplF]={'On'}), maybe you want something like:

If(sum({<[Month]=, [EmplF]={'On'}>} [Nrb_Empl])>'0',sum({<[Month]=,[LeaveC]=>}[Nrb_Empl_Leav])/
sum({<[Month]=,[EmplF]={'On'},[LeaveC]=>} [Nrb_Empl]/12),0)

[abhijitnalekar · Accepted solution]

If(sum({<[Month]= ,[EmplF]={'On'}>}[EmplF])>'0'

,sum({<[Month]=>}{<[LeaveC]=>}[Nrb_Empl_Leav])/
(sum({<[Month]=,[EmplF]={'On'},[LeaveC]= >}[Nrb_Empl])/12),0)