7 Replies Latest reply on Nov 1, 2017 11:02 AM by Avinash Suravarapu

    Using IF,THEN,IFELSE Calculation for Dates

    Alexander Rom

      I am looking to use an IF,THEN,IFELSE Calculation to sort by dates. I have done this for Sums (i.e

      IF

      [Sum] < 0 THEN "0-286"

      ELSEIF

      [Sum] <= 287 THEN "287-573"

      ELSEIF

      [Sum] <= 574 THEN "574-860"

      ELSEIF

      [Sum] <= 8610 THEN "Everything Else"

      END

       

      I am looking to do the same premise but using [DATE]. Basically, IF [DATE] is before (less than) THEN Display as "Month-Month".  I tried achieving this by using Parameters, but it failed to execute as I wanted it to. I am assuming that the IF, ELSEIF can most likely only be applied to Sums, Profits etc...  I also looked into Bins for Dates but it does not display a range.

       

      Thoughts?