Hi guys,
i need your help.
In Analytics studio i add a fomula columns with this formula:
case
when '
' == "Alessandro Marcioni" && sum(Netto_ADV__c)>= 650000 then 1500
when '
' == "Antonio Amendola" && sum(Netto_ADV__c) >= 300000 then 1500
when '
' == "Christian Morico" && sum(Netto_ADV__c) >= 830000 then 1500
when '
' == "Daniele Tinelli" && sum(Netto_ADV__c) >= 400000 then 2000
when '
' == "Fulvio Caccialupi" && sum(Netto_ADV__c) >= 520000 then 1500
when '
' == "Ilaria Bruno" && sum(Netto_ADV__c) >= 560000 then 1500
when '
' == "Marco Franco Selvi" && sum(Netto_ADV__c) >= 600000 then 1500
when '
' == "Rosario Loddo" && sum(Netto_ADV__c) >= 580000 then 1500
when '
' == "Sergio Staiti" && sum(Netto_ADV__c) >= 750000 then 1500
when '
' == "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
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