6 Replies Latest reply on Mar 13, 2017 7:07 AM by sam.hong.0

    Calculations with Percentage Changes and Mapping (WORKBOOK ATTACHED)

    sam.hong.0

      Hello,

       

      I am having a little difficulty in having my calculation produce the right result as well as would like feedback on seeing if the calculation is efficient.

       

      Please see workbook attached.

       

      Issue

       

      (1) My calculation for "Year: Change" is valid, but for rows where it is NULL, it does not say "No Change" as indicated by my calculation.

       

      Request

       

      (1) Is it possible to create a parameter that would allow a user to pick and choose which years they want to pick? For example, I have number of events hard coded per each year (2012, 2011) but I would like to be able to allow a user to select any year and have the table updated.

       

      (2) I am having trouble finding a way to convert this comparison to Quarters and Months. Would this be possible?