FavoritosTommaso Romagno (Nicolaus Tour) publicou em * CRM Analytics 日本 *(旧 Tableau CRM) (Originalmente perguntado por Tommaso Romagno)13 de jun. de 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 MichalikMostrar maisAdicionar um comentárioEscrever um comentário...NegritoItálicoSublinhadoTachadoLista com marcadoresLista numeradaAdicionar linkBloco de códigosInserir imagemAnexar arquivosURL do linkCancelarSalvar0/9000Responder
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 MichalikMostrar mais