Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try setting the Total Mode of your expression to Sum Of Rows
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
Try setting the Total Mode of your expression to Sum Of Rows
Thank you so much Marcus.
I never think about this option.
Best regards,
David
Thank you for your help Anand.
Have a nice day,
Best,
David