0 Replies Latest reply on Dec 9, 2013 5:39 AM by Prateek Bhandari

    logical functions using dates condition

    Prateek Bhandari


      Hi there,

       

      Thanks in advance for your help. As a beginner to Tableau, I am still learning my way through the basics, so apologies if this is a very simple question.

       

      I was trying to workout a way where I can apply logical conditions into a month on month measure.

       

      What I am looking for is:

       

      (1) a formula that would cover for example: if I made a sales a revenue of 100 in Jan and my profit was also 100 in Jan, then a condition that would say 'if sales=profit, then exc. or else inc.'.

      (2) a formula that would be derived from (1) in the sense that for example: 'if Jan=exc but Feb=inc then catch-up else none'

       

      I have attached a an Excel sheet to show exactly what I am looking for.

       

      Any help would be much appreciated!

       

       

      Many thanks,

       

      Prateek