Sum up null values

[SamuelHaag]

Hi guys,

is it possible to sum up null values in a expression? For example: I want to have the sales of specific[CustomerGroup]  and the given null values: 

(sum({<

[CustomerGroup] = {'0001', '0003', '0004', NULL}

>}

Sales))

I tried it already with excluding but it didn't work either 😞

Thanks

Samuel

[Kushal_Chawda]

may be this

=sum({<[CustomerGroup] = {'0001', '0003', '0004'}>+<[CustomerGroup]={"=len(trim([CustomerGroup]))=0"}>}Sales)

[SamuelHaag]

This is a good idea! Unfortunately it didn't work

[tresesco · Accepted solution]

Try like:

sum({1-<[CustomerGroup]={*}>+<[CustomerGroup] = {'0001', '0003', '0004'}>}Sales)