Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All - the expression below is not functioning properly. Each line is intended to populate a bar on a bar chart. It loads from the script but does not populate the bars of a bar chart as it should. I know there are probably better ways to calculate this but looking to understand other options. We are also using the '*' as a wildcard function, but thinking this is not proper usage either. Thanks!!
IF ([Case Type] = 'Employee', Dual('Employee', 1)),
IF ([Case Type] = 'Agent*' AND ([Net Loss (USD)]>10000), Dual('Agent>10k', 2),
IF ([Case Type] = 'Policy*' AND ([Net Loss (USD)]>10000), Dual('POS >10k', 3),
IF ([Case Type] = 'Procure*' AND ([Net Loss (USD)]>100000), Dual('Procurment >10k', 4),
IF ([Case Type] = 'Claim' AND ([Net Loss (USD)]>250000), Dual('Claims >250k', 5),
IF ([Case Type] = 'Under*' AND ([Net Loss (USD)]>250000), Dual('U/W >250k', 6))))))as SigCases,
You close of the first if statement too soon, furthermore use wildmatch to compare with wildcards
IF ([Case Type] = 'Employee', Dual('Employee', 1)),
IF ([Case Type] = 'Agent*' AND ([Net Loss (USD)]>10000), Dual('Agent>10k', 2),
IF ([Case Type] = 'Policy*' AND ([Net Loss (USD)]>10000), Dual('POS >10k', 3),
IF ([Case Type] = 'Procure*' AND ([Net Loss (USD)]>100000), Dual('Procurment >10k', 4),
IF ([Case Type] = 'Claim' AND ([Net Loss (USD)]>250000), Dual('Claims >250k', 5),
IF ([Case Type] = 'Under*' AND ([Net Loss (USD)]>250000), Dual('U/W >250k', 6))))))asSigCases,