I'm trying to do a simple calculation with a couple fields. I have the following setup
Total Points Field (Calculation field)
Split Field (Category Field, has two options Yes/No)
Agent Points (Calculation field)
I want to create another calculation field (Agent Points) that divides the Total Points Field by 2 or by 1 depending on whether the Split Field is Yes or No.
For example, if the Total Points Field = 1,000 and the Split Field is Yes then divided by 2, so the Agent Points will be 500 if not divided by 1
Thank you in advance!
Please sign in to leave a comment.