7 Replies Latest reply: Jan 9, 2018 10:22 AM by Denis LOMAKIN RSS

    Date Greater then variable in dimention

    Denis LOMAKIN

      Hi all,

      I am trying to create a Bar Chart with Dimension like this:

      If(Date >= $(vMaxDateforDimen), Month).

      Means the dimension will display only Months that are greater than Max date based on selection


      vMaxDateforDimen = monthend(AddMonths(Max(dimSurveyReceivedDateItself),-$(vNumRollinMonth)))


      vNumRollinMonth is a number that user can change to see more or less Months of data.

      I cannot add it into expression as I have Alternative dimensions as Quarters and Years that should be affected by this formula.

      Please help.