4 Replies Latest reply on Oct 4, 2018 6:53 AM by meenu choudhary

    True|False Calculation: When measures move in the same direction, then true, else false

    michael.pigman

      Hi everyone,

      I am pretty stumped on a calculation. I have looked through the forum and google without much luck. Unfortunately, I can't post the workbook due to financial information.

       

      I need a T|F that does as follows:

      IF [measure 1] increases relative to the previous period AND [measure 2] increases relative to the same previous period THEN "TRUE"

      ELSEIF [measure 1] decreases relative to the previous period AND [measure 2] decreases relative to the same previous period THEN "TRUE"

      ELSE "FALSE"

       

      Essentially, I just need a true false statement that says true if two measures rise or fall together. In the example above, I would want to filter out true so I can see the exceptions in the view, where they do not move in the same direction. They don't have to increase the same amount, they just have to be directionally true to each other.

       

      Thank you for your help.