Calculation condition. Multiple values.

[blunckc1]

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

[swuehl · Accepted solution]

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?

[blunckc1]

Thanks for the quick reply Stefan.

The AND operator worked, I feel rather silly for not using that in the first place.

[dsharmaqv]

Try this

GetSelectedCount([Time Category A])=0 And GetSelectedCount([Payment Type Category])=0