TOTAL of IF statement and variable in straight table

[#1]

Hello Community!

I tried to find a solution in existing discussions but were not successful.

I have this expression in a straight table to calculate New Freight:

if(vSaleSize<(sum([SaleAmount])),[Freight]=0,[Freight])

vSaleSize is my variable.

But when I sum this expression , it returns 0 in Total.

Can you help me please on that point.

Best regards,

David

[its_anandrjs]

Hi,

Try this

if(vSaleSize<(sum([SaleAmount])), 0 ,[Freight])

Or what is the definition of the vSaleSize variable.

Or

if(vSaleSize < (sum(TOTAL [SaleAmount])), 0 ,[Freight])

Regards,

Anand

[marcus_malinow · Accepted solution]

Try setting the Total Mode of your expression to Sum Of Rows

[#4]

Thank you so much Marcus.

I never think about this option.

Best regards,

David

[#5]

Thank you for your help Anand.

Have a nice day,

Best,

David