Can anyone help?
"a0M0g00000JVmbD,"&
IF(System_Type__c = "Energy Storage","a0M7000000JCrgt",
Case( Financing__c,
"Cash","a0M0g00000JVmbS",
"Lease - Monthly","a0M7000000ITNO4",
"Lease - Prepaid Due Before Installation","a0M7000000ITNO4",
"PPA - Monthly","a0M7000000JDBja",
"PPA - Prepaid Due Before Installation","a0M7000000JDBja",
"PPA - Prepaid PACE Combo","a0M7000000JDBja",
"a0M0g00000JVmbN"))
&IF(ADDENDUM_System_Sizing__c == TRUE,",a0M7000000H6MZi", "")
&IF(ADDENDUM_Historical_Usage__c == TRUE, ",a0M7000000H6MZs", "")
&IF(ADDENDUM_North_Facing_Roof__c == TRUE, ",a0M7000000H6MZx", "")
&IF(Addendum_New_Construction__c == TRUE, ",a0M0g00000J21wR","")
&IF(ADDENDUM_Premium_Warranty__c == TRUE, ",a0M7000000H6Ma7", "")
&IF(AND(ADDENDUM_Shade__c == TRUE,OR(ISPICKVAL(Financing__c,"Lease - Monthly"),
ISPICKVAL(Financing__c,"Lease - Prepaid Due Before Installation"))), ",a0M7000000ISD3G", "")
&IF(AND(ADDENDUM_Shade__c == TRUE,NOT(OR(ISPICKVAL(Financing__c,"Lease - Monthly"),
ISPICKVAL(Financing__c,"Lease - Prepaid Due Before Installation")))), ",a0M7000000ISD3L", "")
&IF(ADDENDUM_Manager__c == TRUE, ",a0M7000000HtcN4", "")
&IF(ISPICKVAL(Mounting_Plan__c, "Ground-Mount") ,",a0M7000000ITM7U", "")
&IF(Addendum_Wheelhouse__c == TRUE, ",a0M0g00000Kf2ZK","")
&IF(Addendum_SDMCU__c == TRUE, ",a0M7000000ITM7Z","")
&Case(Service_Provider__c ,
"SDG&E", ",a0M7000000ITw0v",
IF( AND( ISPICKVAL(Service_Provider__c,"SCE"),
(System_Size_kW__c >= 10)), ",a0M0g00000JVqMY",",a0M0g00000JVqZD"))
3 个回答
