To calculate the formulas

[Anonymous]

Hi Everyone,

I have a requirement where I need to calculate the GP% and $GP for my quotes, but somehow I'm getting the weird values. Can you help me with the stuff.

Formula:

GP% = (Resale- Cost)/Resale

$GP = Ext Resale - (Cost* Quantity).

Attached is the xls and qvf file.

Thanks and Regards,

Drishti Goel

[alejortizp]

try this:

Sum((Resale - Cost)/Resale)/Count(TOTAL [Line Number])