お気に入り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表示件数を増やす