Skip to main content
GruposSalesforce OmniStudio DeveloperPergunta de Alpish Jain
Alpish Jain (salesforce) perguntou em Salesforce OmniStudio Developer
15 de out. de 2024, 05:18

Requesting help in returning a empty list in dataraptor formula

Hi everyone, I created a dataraptor formula as below

IF(ISNOTBLANK(%LoanApp:Applicant:axisltd_Total_Net_Income__c%) && ISNOTBLANK(%LoanApp:Applicant:axisltd_Total_Other_Income__c%), FUNCTION('AxisOmniGetPicklistLabel','getIncomeDetail',(%LoanApp:Applicant:axisltd_Business_Income_Source__c%+'$'+%LoanApp:Applicant:axisltd_Total_Net_Income__c%+'$'+%LoanApp:Applicant:axisltd_Total_Other_Income__c%+'$'

+%LoanApp:Applicant:axisltd_Other_Income_Source__c%+'$')), [])

 

I want this formula to return [] if both incomes are blank.Any suggestions on this?

 

#Omnistudio #DataRaptor #Salesforce Developer #Salesforce

1 resposta
  1. Paul Kuriyan (Anonymous)
    15 de out. de 2024, 05:41

    IF(

        AND(

            ISNOTBLANK(%LoanApp:Applicant:axisltd_Total_Net_Income__c%), 

            ISNOTBLANK(%LoanApp:Applicant:axisltd_Total_Other_Income__c%)

        ), 

        FUNCTION(

            'AxisOmniGetPicklistLabel',

            'getIncomeDetail',

            (

                %LoanApp:Applicant:axisltd_Business_Income_Source__c% + '$' + 

                %LoanApp:Applicant:axisltd_Total_Net_Income__c% + '$' + 

                %LoanApp:Applicant:axisltd_Total_Other_Income__c% + '$' + 

                %LoanApp:Applicant:axisltd_Other_Income_Source__c% + '$'

            )

        ), 

        []

    )

Escrever uma resposta...
0/9000