evaluate an expression for excluded values in a particular field.

[#1]

Hi All,

I was trying to evaluate an expression for excluded values in a particular field. using 1-$ evaluates the expression for all excluded values.

How do I accomplish this only for 1 or 2 fields?

Thanks,

Neeraj

[#2 · Accepted solution]

Try this:

Plz find the attached file.

[#3]

Hi

Please Use this formula.

sum(if(FieldName<>'FieldValue',Amount))

Regards

Ashish

[#4]

Neeraj is looking for solution to get a two dimensional selection.

First one to get a exclueded value, and the second one for getting more granulity on the second label.

1-$ value is going to give the exluded value for first time selected value.

But it will not work, if there is another granulity label associated with the selection.

So it is a set analysis inside set analysis.

Please give your suggestion according for that

Regards,

Lalmohan

[#5]

Thank you Erica.