L
Linda Wampach
I want to create a field within a report based upon
whether another field is true or false. Not only that,
but I want to be able to calculate that field. For
instance:
Typically, the TOTALUNITS field would be calculated by
using a =Sum[Units]expression. I want to be able to
multiply the TOTALUNITS by .7 if another field (yes/no
field) called MANAGER is = yes. Otherwise, I want to just
sum the field.
I need to do this in the report.
Any ideas?
whether another field is true or false. Not only that,
but I want to be able to calculate that field. For
instance:
Typically, the TOTALUNITS field would be calculated by
using a =Sum[Units]expression. I want to be able to
multiply the TOTALUNITS by .7 if another field (yes/no
field) called MANAGER is = yes. Otherwise, I want to just
sum the field.
I need to do this in the report.
Any ideas?