1 Reply Latest reply on Jun 26, 2018 4:56 AM by Zhouyi Zhang

    Conditional calculation current-previous year

    Valentina Bussi

      Hello,

      I have a table structured in this way, where the values show if a member made at least a booking in the above year:

       


      Year of booking
      Member id20172018
      1231
      2341
      34511
      4561
      5671
      67811
      78911
      8901
      9011

       

      The year of booking can be changed through a parameter, so the previous-current year values are related to the selection in it.

      I need to calculate the number of members who purchased in the previous year (2017) but NOT in the selected year (2018), so that only the values in green should be summed.

      I've already tried with a combination of IF formulas, but without any success.

      Can anyone help me with that?

      Thank you

      Valentina