Calculation field - set to not re evaluate
I have a calculation based on four fields
Annual Premium - manual entry - number field
API - calculation - number field using (case to work out if provider X is selected which value to set in API field
API Calculation - calculation field - number field using case to work out a percentage based on which provider selected
commission amount is a calculation based of the four above fields
Commission Field (Annual Premium*API*API Calculation) = commission amount
All of the above works fine but I will need to amend the API Calculation % in the future and don't want the old values to change/recalculate and I am trying to work out the best way to do it.
I would appreciate any suggestions!!!
Thanks in anticipation of your help