Adding Null value dimensions

[zagzebski]

I have a field called Group Size with values L, S, and M. however sometimes there is a null value in this field but there are $'s that need to be account for..example:

Group A , Size L = $100

Group B, Size M = $200

Group C, Size S = $300

Group D, Size (null) = $400

What would the set analysis be for Size = L + S + Null Values in an object?

Currently I have this part in the expression which works fine:  = {'L'}+{'S'}

but don't know how to add the null portion.

[MayilVahanan]

HI

So you want to exclude the M value correct?

If so, you can try like this

Sum({<Size -={'M'}>}Sales)

Hope it helps

[zagzebski]

Thanks for the response. I probably oversimplified.

thre is actually many "Size" values. How do I get only:

(1) "L"

(2) "S"

(3) null values

[MayilVahanan]

HI

Try like this

sum({<Size -={'*'}> + <Size={'L','S'}>} Sales)

hope it helps

[zagzebski]

Thanks.

can you explain how this accounts for null values: Size -={'*'}

[MayilVahanan]

HI

* represents all values in the field

- = exclude the values.

so, size-={'*'}  exclude all values in the field, it include only null values.

hope you can understand now.

[zagzebski]

So simple!. Thanks so much...