Crystal 9, PSQL 9, W2003 server.
I have a report where I'm taking a specific Code Category, Sale amount, dividing it by Lbs sold to get $/Lb.
Code Total Lbs Sold Sale Amount $/Lb
60 172.80 $392.80 $2.2731
For Total Lbs Sold I'm using {Qty Sold} * {Item Weight}
For Sale amount I'm taking the (Sum(Sale Amount)) and for
$/Lb I'm taking (Sum(Sale Amount)) and dividing by Total Lbs Sold.
The actual computed (w/calculator) for Code 60 is $2.2731, but when I run my report I get a figure of $2.0371.
For Sale Amount there is more than 1 amount that it's adding up for total, but when it tries to figure out the $/Lb, it's only taking the first amount in the total field, hence giving an incorrect $/Lb total.
Hope that's clear enough. Any help is appreciated.
PS-I tried inserting the (Sum(Sale Amount)) into my $/Lb formula but get error:
A summary has been specified on a non-recurring field.
Gene
I have a report where I'm taking a specific Code Category, Sale amount, dividing it by Lbs sold to get $/Lb.
Code Total Lbs Sold Sale Amount $/Lb
60 172.80 $392.80 $2.2731
For Total Lbs Sold I'm using {Qty Sold} * {Item Weight}
For Sale amount I'm taking the (Sum(Sale Amount)) and for
$/Lb I'm taking (Sum(Sale Amount)) and dividing by Total Lbs Sold.
The actual computed (w/calculator) for Code 60 is $2.2731, but when I run my report I get a figure of $2.0371.
For Sale Amount there is more than 1 amount that it's adding up for total, but when it tries to figure out the $/Lb, it's only taking the first amount in the total field, hence giving an incorrect $/Lb total.
Hope that's clear enough. Any help is appreciated.
PS-I tried inserting the (Sum(Sale Amount)) into my $/Lb formula but get error:
A summary has been specified on a non-recurring field.
Gene