Values on selections

[#1]

Hi Experts,

I have the data like:

Name	Value
A	6
B	0
C	5
D	0
E	0
F	4

I have created a list box with value Name,

My requirement is that when Name = A or B or C is selected, value should be 'NA' or

if the Name selected is (A and B) or (A and C) or (B and C) , value should be 'NA' or

Name is A and B and C , value should be 'NA'

else it should display sum(Value)

PS: I don't want to put so many if conditions. Is there any easy or short way to handle this?

Regards,

Anjali Gupta

[swuehl · Accepted solution]

Maybe like

If( Count({<Name *= {D,E,F}>} Name), Sum(Value), 'NA')

or

If( Count({<Name -= {A,B,C}>} Name), Sum(Value), 'NA')

[#3]

Hi swuehl,

This is not working. It is showing sum(Value) as 0, instead i want 'NA'.

[swuehl]

It's working for me.

Seems like I have't fully understood your setting according the information provided.

[#5]

Thanks swuehl,

The second one worked for me.

If( Count({<Name -= {A,B,C}>} Name), Sum(Value), 'NA')

Regards,

Anjali Gupta