Hi,
I'm writing an invoice report (Crystal 7.0) and I'm running into problems calculating the line item discount and arriving at the correct extended amount.
My discount field returns a value of "60.00" for a 60% discount - and I think that's one of my problems.
Formula Example:
if {SORDETAIL.MDiscPct1} = 100 then 0
else
{SORDETAIL.MPrice} - {SORDETAIL.MDiscPct1} * {SORDETAIL.MOrderQty} + {@LineTax}
Field Values:
Qty is: 1
Unit price is: $285,000.00
Unit Discount is: 60% (field returns a value of 60.00)
Tax is: 0.00
My report keeps returning a total of: $284,940.00
(that's the unit price minus 60 dollars, not 60%)
I know this is an elementary question, but I'm at my wits end.
Can someone help me write a formula that gives me the correct extended line item total?
Thanks in advance!
I'm writing an invoice report (Crystal 7.0) and I'm running into problems calculating the line item discount and arriving at the correct extended amount.
My discount field returns a value of "60.00" for a 60% discount - and I think that's one of my problems.
Formula Example:
if {SORDETAIL.MDiscPct1} = 100 then 0
else
{SORDETAIL.MPrice} - {SORDETAIL.MDiscPct1} * {SORDETAIL.MOrderQty} + {@LineTax}
Field Values:
Qty is: 1
Unit price is: $285,000.00
Unit Discount is: 60% (field returns a value of 60.00)
Tax is: 0.00
My report keeps returning a total of: $284,940.00
(that's the unit price minus 60 dollars, not 60%)
I know this is an elementary question, but I'm at my wits end.
Can someone help me write a formula that gives me the correct extended line item total?
Thanks in advance!