Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
sum({1-<[CustomerGroup]={*}>+<[CustomerGroup] = {'0001', '0003', '0004'}>}Sales)
may be this
=sum({<[CustomerGroup] = {'0001', '0003', '0004'}>+<[CustomerGroup]={"=len(trim([CustomerGroup]))=0"}>}Sales)
This is a good idea! Unfortunately it didn't work
Try like:
sum({1-<[CustomerGroup]={*}>+<[CustomerGroup] = {'0001', '0003', '0004'}>}Sales)