Ajouter aux favorisTommaso Romagno (Nicolaus Tour) a publié du contenu dans * CRM Analytics 日本 *(旧 Tableau CRM) (Question initialement posée par Tommaso Romagno)13 juin 2025, 11:07Tommaso RomagnoAdd filter in case when formula in a formula column in analytics studioHi 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 MichalikAfficher plusAjouter un commentaireRédiger un commentaire...GrasItaliqueSoulignerBarréListe à pucesListe numérotéeAjouter un lienBloc de codeInsérer une imageJoindre des fichiersURL du lienAnnulerEnregistrer0/9000Répondre
Tommaso RomagnoAdd filter in case when formula in a formula column in analytics studioHi 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 MichalikAfficher plus