Forum Discussion

MaximumGroup's avatar
MaximumGroup
Qrew Trainee
7 years ago

I am trying to create a new formula for different Deal Types.

I am trying to create a new formula for different Deal Types. If Deal Type 1 or Deal Type 2 is selected then one field plus another field- 400. deal type 3 is selected then this field + this field....
MaximumGroup's avatar
MaximumGroup
Qrew Trainee
7 years ago
Thanks that was perfect!  

I am needing to add to this formula.  If I want a specific field to determine the -948 such as Sales Team.  If your on Sales Team A you get 
[Deal Type] = "RCI Points",[Down Payment]+[Balance Due]-948) 
Sales Team B gets 
[Deal Type] = "RCI Points",[Down Payment]+[Balance Due])