I am working on a commission report where the commission paid is based on the profit margin of the product sold and the products the salesmen sells. The higher the margin the higher the commission and if the salesperson is responsible for product line 1 his commission levels are X if a different salesperson is responsible for product line 2 his commission levels Y.
I would like to write a variable declaration formula that looks like this:
numbervar commission1
numbervar commission2
numbervar commission3
numbervar commission4
If "salesterritory" = ProductLine1 Then
commission1 := 0.05
commission2 := 0.1
commission3 := 0.15
commission4 := 0.20
Else
commission1 := 0.025
commission2 := 0.05
commission3 := 0.075
commission4 := 0.01
However I always get errors stating that the remaining text does not appear to be part of the formula. Is my idea possible?
Thanks.
I would like to write a variable declaration formula that looks like this:
numbervar commission1
numbervar commission2
numbervar commission3
numbervar commission4
If "salesterritory" = ProductLine1 Then
commission1 := 0.05
commission2 := 0.1
commission3 := 0.15
commission4 := 0.20
Else
commission1 := 0.025
commission2 := 0.05
commission3 := 0.075
commission4 := 0.01
However I always get errors stating that the remaining text does not appear to be part of the formula. Is my idea possible?
Thanks.