AnsweredAssumed Answered

Calculation field - set to not re evaluate

Question asked by MT_2 on Feb 25, 2015
Latest reply on Feb 27, 2015 by philmodjunk


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