You need to sign in to do that
Don't have an account?
sundhar.mks1.3962649227519546E12
Field auto populate on particulay layout
Please add a field to the Visit object, but do not add it to any of the layouts, called " GP Margin Range " . This field needs to auto populate as one of the following ranges: " 0-30%, 30-40%, 40-50%, 50%+ ", based on the value in the Estimated GP Margin field.
E.G. if the Estimated GP Margin is 43% the GP Margin Range should be 40-50%.
E.G. if the Estimated GP Margin is 43% the GP Margin Range should be 40-50%.
if Estimated GP Margin field type is Percent, you can create a new formula field, Formula Return Type: text and use the following:
IF( AND( 0 < Estimated_GP_Margin__c, Estimated_GP_Margin__c <= 0.3), "0-30%",
IF( AND( 0.3 < Estimated_GP_Margin__c, Estimated_GP_Margin__c <= 0.4), "30-40%",
IF( AND( 0.4 < Estimated_GP_Margin__c, Estimated_GP_Margin__c <= 0.5), "40-50%",
IF( 0.5 < Estimated_GP_Margin__c, "50%+" , null ))))