+ Start a Discussion
sundhar.mks1.3962649227519546E12sundhar.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%.
AgiAgi
Hi,

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 ))))