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

    Help with LOD calculation

    mark.reves

      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])}

      END

       

      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 !