Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this:
Sum((Resale - Cost)/Resale)/Count(TOTAL [Line Number])