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

[sunny_talwar]

So like this?

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

[master_student]

there are errors in your expression

[sunny_talwar]

Yes my bad, I forgot a parenthesis within my first condition:

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

[master_student]

[sunny_talwar]

Is your field name all Upper case?  May be this:

If(Len(Trim(LB)) > 0 and Sum(POKTND) > 0, Sum(POKTND))

These are things we won't know so you have to make sure that you take care of them at your end

[master_student]

Thanks for your help sunny. The fields names are correct.

[sunny_talwar]

So did it work or not?

[master_student]

no

[sunny_talwar]

Have you tried clicking ok to see if you see any result or not? Where are you using this condition? Would be able to share screenshots of your LB and POKTND/poktnd field? To make both our life easier, would you be able to share a sample?