D
D. Austin
I am trying to calculate the pecentage of sales on a report My detail line
has the following two fields
[ACCT_TYPE] [YTD_AMT]
I want to create an expression that calculates the percentage of sale. If
the ACCT_TYPE equals SALES then make that amount the denominator and
calculate the perctage for all other ACCT_TYPE. Also if I get a div by Zero
error I want the value set at zero.
has the following two fields
[ACCT_TYPE] [YTD_AMT]
I want to create an expression that calculates the percentage of sale. If
the ACCT_TYPE equals SALES then make that amount the denominator and
calculate the perctage for all other ACCT_TYPE. Also if I get a div by Zero
error I want the value set at zero.