AnsweredAssumed Answered

help with calulation

Question asked by AaronRoss on May 15, 2012
Latest reply on May 15, 2012 by philmodjunk


help with calulation


Hello. I am trying to set up a payroll calulation field and i need help.  Basically what i want is a field that will return the payout of a rep based on if their base pay is greater than their commission it will return what their base pay is, but if their commison is greater than their base pay it will return their commssion.

ok, first i have 50 fields called DBA 01 - 50. Each DBA field = $14 depending on how many company names i put it. EX:  1 DBA = $14 while 7 DBA = $98 (14*7)

second, i have a field called Commission that mulitpies each DBA field by $14 giving me an estiment on payroll.

lastly, i have a field called Base Pay that mulipies whatever hours i put in by 7.25

Now i have a field called Pay out and ive tried this: If ( Base Pay > Commission; Base Pay  or If (Commsion > Base Pay; Commsion) ) but it doesnt return what i want. I hve also tried this 3 different way but still nothing works...

what am i missing?