Hi,
I’m trying to create a control filter using parameter. For that purpose, I have created a parameter (lets say ‘filters’), passed ‘All’ as a static value, and created a control filters and passed ‘All’, ‘A’ and ‘B’ as a list.
Now I’m trying to create a calculated field so that can be used as filter, if i write two condition separately, then it works, for example
calculted_field =
ifelse(
${filters} = ‘All’, 1,
${filters} = ‘A’ AND {num_logs_with_authorizations_percentage} < .98 , 1,
0
)
it works and following code works too.
calculted_field =
ifelse(
${filters} = ‘All’, 1,
${filters} = ‘B’ AND isNull({num_logs}), 1,
0
)
But if I put these 2 condition together, then it doesn’t work, it found an error,
calculted_field =
ifelse(
${filters} = ‘All’, 1,
${filters} = ‘B’ AND isNull({num_logs}), 1,
${filters} = ‘A’ AND {num_logs_with_authorizations_percentage} < .98 , 1,
0
)
the above is not working, find an error. How can I overcome this problem
Any advice will be helpful.
Thank you