Amount to display

[master_student]

Hello community,

I would like to set a condition

if sum(poktndd) >0 and IS NOT NULL(LB) => sum(poktndd)

else don't display the amount / sum(poktndd)

Any idea please?

Thanks

[master_student]

Sorry

now the expression is correct

but here's the result :

I want that those records to disappear with '-'

[sunny_talwar]

If LB is your dimension, why don't you select 'Suppress When Value Is Null' on the dimension tab to remove all those records where LB is null?

[master_student]

I don't want to suppress whene LB is null, because there are LB nulls and the amount POKYNDD is not null, I want this line to appear

[sunny_talwar]

It seems you have more than one expression in your chart. You might need to use this logic for all your expressions.

If(Len(Trim(LB)) > 0 and Sum(poktndd) > 0, OtherExpressions)