condition "is not null" or "is null" in sum

[#1]

Hi !

is anyone know is it posible to fill condition isnull(fieldname) inside dimention condition:

i try to build somethng like this:

=sum({<bg_t={isnull(bg_t)},id=>} Quantity)

but it does't work

[Gysbert_Wassenaar · Accepted solution]

try this instead:

=sum({<bg_t-={'*'},id=>} Quantity)

[Anonymous]

You try to put isnull() inside double qoutation marks ".

E.g

=sum({$<Customer={"=isnull(Address)"}>} Customer)

Regards

MultiView

[#4]

thank you !!!!!

[#5]

thank you, Multi View !!!

=sum({<bg_t-={"=isnull(bg_t)"},id=>} Quantity_i)

i tis also works