Calculation for report

  • Thread starter Thread starter Ron Greenbank
  • Start date Start date
R

Ron Greenbank

I have a report finished except for one detail. It is an inventory report
that is straight forward for all items except one. I need to break down one
of the field entries based on a percentage that is entered in another field.
For example: Shipment of a certain weight.
90% of the shipment weight is one kind of commodity
10 % is another type. The arrive mixed and are
separated by machine.
If I can calculate one the other would be of course the remainder.
What I need to do is if the current field on the report matches this
commodity then do the calculation and show results on the report. Other
commodities are also part of the report so they do not need any further
manipulation. Just this one infrequent case.
I would appreciate any help you could offer.
Ron
 
Ron said:
I have a report finished except for one detail. It is an inventory report
that is straight forward for all items except one. I need to break down one
of the field entries based on a percentage that is entered in another field.
For example: Shipment of a certain weight.
90% of the shipment weight is one kind of commodity
10 % is another type. The arrive mixed and are
separated by machine.
If I can calculate one the other would be of course the remainder.
What I need to do is if the current field on the report matches this
commodity then do the calculation and show results on the report. Other
commodities are also part of the report so they do not need any further
manipulation. Just this one infrequent case.
Click to expand...


I'm not sure what calculation you want to do, but maybe all
you need is tow text boxes, one for each of the two types.
The text boxes can use expressions like:

=IIf(typefield = certaintype, percentfield * weight, weight)

=IIf(typefield = certaintype, (1 - percentfield) * weight,
Null)
 
Back
Top