Calculations

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

I am trying to calculate commissions. Some of the projects
only get half of the commission and some get the whole
commission. How can I put this in one report that includes
all of the projects commissions correctly?

Thanks
 
I am trying to calculate commissions. Some of the projects
only get half of the commission and some get the whole
commission. How can I put this in one report that includes
all of the projects commissions correctly?

Thanks
Click to expand...

You could add an unbound control to the report:
=IIf([HowMuchCommission] = "GetsHalf",Format([Commission] *
..5,"#,###.00"),[Commission])
 
Thanks!! That did the trick! :)
-----Original Message-----
I am trying to calculate commissions. Some of the projects
only get half of the commission and some get the whole
commission. How can I put this in one report that includes
all of the projects commissions correctly?

Thanks
Click to expand...

You could add an unbound control to the report:
=IIf([HowMuchCommission] = "GetsHalf",Format([Commission] *
..5,"#,###.00"),[Commission])
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top