收藏Tommaso Romagno (Nicolaus Tour) 发布于 * CRM Analytics 日本 *(旧 Tableau CRM) (原提问者 Tommaso Romagno)2025年6月13日 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 Michalik显示更多添加评论撰写评论...粗体斜体下划线删除线项目符号列表编号列表添加链接代码块插入图像附加文件链接 URL取消保存0/9000回复
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 Michalik显示更多