Hey Everybody,

I am trying to figure out how to put the annual sales revenue in a field (in deals).

Basically, my sales reps get paid on a tier system, the more they sell the more they get paid. Right now the look on a spreadsheet which tells them which tier they are in and then they can tell how much commission they will get.

I would like that tier to be calculated in a field and to do it, I need the annual sales "Amount" for each sales rep to be brought into a field. Then I can calculate the tier and commission for them with no chance of mistake.

Does anybody have an idea of how to do it? My first instinct is to go to Creator, but I'm not familiar with it, so I am hoping that there is a straight forward method.