Skip to main content

Hi guys,  

i need your help.  

In Analytics studio i add a fomula columns with this formula: 

 

case  

when '

RefOrder.Name

' == "Alessandro Marcioni" && sum(Netto_ADV__c)>= 650000 then 1500 

when '

RefOrder.Name

' == "Antonio Amendola" && sum(Netto_ADV__c) >= 300000 then 1500 

when '

RefOrder.Name

' == "Christian Morico" && sum(Netto_ADV__c) >= 830000 then 1500 

when '

RefOrder.Name

' == "Daniele Tinelli" && sum(Netto_ADV__c) >= 400000 then 2000 

when '

RefOrder.Name

' == "Fulvio Caccialupi" && sum(Netto_ADV__c) >= 520000 then 1500 

when '

RefOrder.Name

' == "Ilaria Bruno" && sum(Netto_ADV__c) >= 560000 then 1500 

when '

RefOrder.Name

' == "Marco Franco Selvi" && sum(Netto_ADV__c) >= 600000 then 1500 

when '

RefOrder.Name

' == "Rosario Loddo" && sum(Netto_ADV__c) >= 580000 then 1500 

when '

RefOrder.Name

' == "Sergio Staiti" && sum(Netto_ADV__c) >= 750000 then 1500 

when '

RefOrder.Name

' == "Walter D'alessandro" && sum(Netto_ADV__c) >= 650000 then 1500 

else 0  

end  

 

i need to add to this formula a filter how i can do this in a formula column in analytics studio? 

Thanks in advance 

Best 

  

@Roman Michalik

2 个回答
  1. 2025年6月13日 11:29

    What kind of filter would you like to add, @Tommaso Romagno

     

    One way could be to work with a nested case statement like 

     

    case when filterfield == value then 

    case when ... then ... else ... end (this is your case statement) 

    else null end

0/9000