Skip to main content
Topics#CollaborationAaron Galaura の質問
Aaron Galaura (Bright Power) が「#Collaboration」で質問
2021年1月13日 21:07

Hi all! I was wondering if anyone could assist me in trimming down this formula. Right now, I'm at 5010 characters.

CASE(pse__Practice__c, 

 

"a2c5000000002xI",(Expected_Value__c/100),

 

"a2c500000000EdL", (1.5*Expected_Value__c/100),

 

"a2c3800000070JV", (3.5*Expected_Value__c/100),

 

"a2c1T000001TUfq", (3.5*Expected_Value__c/100),

 

+

 

IF(pse__Practice__c = "a2c500000000EdQ", IF(pse__Region__c= " a2p50000000Gmcb" || pse__Region__c = "a2p1T000002UcGb", (4.5*Expected_Value__c/100), IF(pse__Region__c = "a2p50000000Grnc", (3.5*Expected_Value__c/100), 0)

 

    ), 

 

    

 

+   

 

    

 

IF(OR(pse__Practice__c = "a2c5000000002xD", pse__Practice__c = "a2c3800000070JL"), IF(NOT(pse__Region__c = "a2p50000000Grnc"),(5*Expected_Value__c/100), IF(pse__Region__c = "a2p50000000Grnc", (3.5*Expected_Value__c/100),0)), 

 

+

 

IF(AND(OR(pse__Practice__c = "a2c5000000002xS",pse__Practice__c = "a2c5000000002x8",pse__Practice__c = "a2c500000000x7Q"), CloseDate < DATE(2020,01,01)), ((0.015*Setup_Fee_s__c)+(0.05*Annual_Recurring_Revenue__c)),

 

+

 

IF(AND(OR(pse__Practice__c = "a2c5000000002x8",pse__Practice__c = "a2c5000000002xS",pse__Practice__c = "a2c50000000147N"), Annual_Recurring_Revenue__c = 0), (1.5*Expected_Value__c/100),

 

+

 

IF(AND(OR(pse__Practice__c = "a2c50000000147N", pse__Practice__c = "a2c5000000002x8", pse__Practice__c = "a2c5000000002xS"), Annual_Recurring_Revenue__c > 0), (0.015*Setup_Fee_s__c)+(0.1*Annual_Recurring_Revenue__c),

 

+

 

IF(AND(OR( pse__Practice__c = "a2c500000000x7Q", pse__Practice__c = "a2c5000000002x8" ), Annual_Recurring_Revenue__c > 0, CloseDate > DATE(2020,01,01)), ((0.015*(Amount -  Annual_Recurring_Revenue__c -  cost_of_goods_sold__c )) + 0.1*Annual_Recurring_Revenue__c), 

 

0))))))) 
4 件の回答
  1. Steve Molis (You Owe Me a Beer, Inc.)
    2021年1月13日 23:52
    You might be able to reduse the Compile Size a bit by changing stuff like this

     

     

    CASE(pse__Practice__c, 
    "a2c5000000002xI",(Expected_Value__c/100),
    "a2c500000000EdL", (1.5*Expected_Value__c/100),
    "a2c3800000070JV", (3.5*Expected_Value__c/100),
    "a2c1T000001TUfq", (3.5*Expected_Value__c/100),

    to something like 

    (CASE(pse__Practice__c, 
    "a2c5000000002xI", 1,
    "a2c500000000EdL", 1.5,
    "a2c3800000070JV", 3.5,
    "a2c1T000001TUfq", 3.5*
    0) * Expected_Value__c / 100)

    that way you're making 1 call to the Expected_Value__c field instead of 4

     

     
回答を記入...
0/9000