Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi world,
I need to apply a calculation condition on a chart so it will only display when no selection is made in 2 separate fields.
The 2 fields are called:
[Payment Type Category]
[Time Category A]
Tried the following if statement but it is failing:
=if(GetSelectedCount([Time Category A])=0 or GetSelectedCount([Payment Type Category])=0,1,0)
Solution?
Cheers
Carl
What do you mean with 'failing'?
And do you require that both fields show no selections (then use an AND operator) or at least one shows no selection?
What do you mean with 'failing'?
And do you require that both fields show no selections (then use an AND operator) or at least one shows no selection?
Thanks for the quick reply Stefan.
The AND operator worked, I feel rather silly for not using that in the first place.
Try this
GetSelectedCount([Time Category A])=0 And GetSelectedCount([Payment Type Category])=0