I am currently using Crystal V.8.5 I have built a cross tab with the following fields:
1) Contracts.NetAmount
2) If not ({Industries.Code} in "ACB", "ACC", "ACA", "TRA", "TRB", "TRN"]) then {Contracts.TradeDiscount} else 0 (TradeDiscount)
3) If ({@trade discount})
> 0 then ({@trade discount})/({Contracts.NetAmount})*100 else 0 (TradePercentage)
I have summed field 1 and field 2, then used a weighted average of field 3 with field 1.
The percentages are right about 60% of the time but they are not always correct. Any ideas would be greatly appreciated!
1) Contracts.NetAmount
2) If not ({Industries.Code} in "ACB", "ACC", "ACA", "TRA", "TRB", "TRN"]) then {Contracts.TradeDiscount} else 0 (TradeDiscount)
3) If ({@trade discount})
> 0 then ({@trade discount})/({Contracts.NetAmount})*100 else 0 (TradePercentage)
I have summed field 1 and field 2, then used a weighted average of field 3 with field 1.
The percentages are right about 60% of the time but they are not always correct. Any ideas would be greatly appreciated!