How to calculate

[dseelam]

Hello All,

Please help

Attached samples, Some how I am not able to calculate PPV Amount expression last column in proper ,Expected result was in text box

Thanks in Advance

[rubenmarin · Accepted solution]

Hi Dinesh, some parenthesys was left:

(sum(Price+(Price*Duty%)+Freight)-([Frozen Cost]))*Qty

And for use monetary values (max 2 decimals for what I see in the table):

Round((sum(Price+(Price*Duty%)+Freight)-([Frozen Cost])), 0.01)*Qty

[dseelam]

It was so dumb I dint notices it thanks Ruben