The discount box does not work properly. It is supposed show a % (SNPct) discount of the total amount (SNAmt). However, it does not do anything. Is there a way to solve this problem?
SQL:
Q_SnSumAmt:
SELECT PurchaseQuoteDtl.SnAmt, PurchaseQuoteDtl.Cost AS SCost, Round([SCost]*[SnPct]) AS Expr1, PurchaseQuoteDtl.SnPct
FROM PurchaseQuoteDtl;