6 Replies Latest reply on Jan 8, 2019 1:49 PM by Michel Caissie

    Help with LOD calculation


      I need to write a IF else LOD calculation something like this :


      IF [customer_name] = ''mark"

      Then { Fixed [customer_name], [company_name] : sum([product sales])}

      Else  { Fixed [customer_name], [company_name] : sum([Profits])}



      when i write this condition i am not seeing the numbers i expect to see. what am i doing wrong here? is there a different way to calculate this using Tableau LOD calculations?


      Thanks for your help in advance !