Set Analysis expression

[vijetas42]

Hi all,

I have 2 values for one of my field like,'ABC' & Null and in set analysis expression i want to calculate value only for Null that is, i want to exclude value 'ABC'

I have wrote expression as sum({<d=P(d)-{'ABC'}>}Sales) but,it's not working.

Please help me out with this expression.

Thanks,

[Anonymous]

try:

sum({<d-={'ABC'}>}Sales)

[#3]

hi,

Try with this

1.- Sum(If(IsNull(d),Sales,0))

2.- Sum({$-<d={'*'}>}Sales)

Regards

[Gabriel]

Hi,

How is the Null generated?

Is it coming from script, as in that's what the data is or result of JOINS?

If that's the case create a Flag for the Null values in the script, this will your UI set analysis.

LOAD

.....

....

,IF(ISNULL(FieldName),1,0)          AS %NullField

FROM SourceFile;