Calculations

[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

 

[fredg]

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

You could add an unbound control to the report:
=IIf([HowMuchCommission] = "GetsHalf",Format([Commission] *
..5,"#,###.00"),[Commission])

 

[Amy]

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

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.
.