6 Replies Latest reply on Jun 22, 2018 5:34 AM by Zachary King

    Show Previous Quarter Values

    Zachary King

      I cannot for the life of me find an answer to this. I am attempting to do the following:

      • show a custom shape if the previous quarter's revenue is either greater than or less than the current quarter. (Up arrow if it is greater/down arrow if it is less)

       

      I realize that I have to create a calculated field that says:

      IF previous quarter revenue > current quarter revenue

      THEN "More"

      ELSEIF previous quarter revenue < current quarter revenue

      THEN "Less"

       

      At that point I drop this onto the shape shelf and that's that. I cannot for the life of me figure out how to do it.