I have the following formula which its telling me is too big.
If(BOA_Score__c>=750, IMAGE("/servlet/servlet.FileDownload?file=0151o000005a2YC", "", 1,1),
If(AND(BOA_Score__c >=250,BOA_Score__c <750), IMAGE("/servlet/servlet.FileDownload?file=0151o000005a2Y7", "", 1,1),
If ( BOA_Score__c <250, IMAGE("/servlet/servlet.FileDownload?file=0151o000005a2Y2", "", 1,1),
Null)))
The BOA Score formula is as follows:-
Differiente__c + GTM_Score__c + Inkjet_Experience_Score__c + Ink_Score__c + New_Existing_Score__c + OEM_Maturity_Score__c + Pm_Gate_Score__c + Segment_Score__c + Xaar_Vs_Application_Score__c
Its just a sum of other fields
Any ideas?
glenn
1 个回答
Hi Glenn,
What is the compilation size of your current formula?Please try the below
IMAGE(
IF(BOA_Score__c>=750,"/servlet/servlet.FileDownload?file=0151o000005a2YC",
IF(BOA_Score__c >=250,"/servlet/servlet.FileDownload?file=0151o000005a2Y7",
"/servlet/servlet.FileDownload?file=0151o000005a2Y2")), "",1,1)
If the above formula is still over the limit, you will have to create a number field and update this number field using the workflow or process builder and then use that number field in the IMAGE formula
