I am trying to create a calculated field filter to return values from a group based upon a parameter value.
Parameter values are:
- 1 = Pay
- 2 = Non Pay
My group values are:
- Pay
- Non-Pay
- Null
In each case I want to keep the null values in the viz.
So pseudo logic would look like this:
If parameter = 1 then group = 'pay' and group = 'null'
elseif parameter = 2 then group = 'non-pay' and group = 'null'
end
Any ideas?
Thanks,
Scott
3 risposte
Norbert,
Thank you for showing me a way to get this done. I was talking with a co-worker who suggested that I use a set vice a group as you can put the same value in more than one set which is a limitation of a group.
Scott
