12 Replies Latest reply: Oct 20, 2016 5:51 AM by Prabir Adhikary RSS

    how to show latest 5 months of data dynamically?

    payal pg

      Hi Community,

      I have a requirement that i need to show the latest 5 months of data,here is the formula that am using that for that


      = IF([Month End Date]>=$(#=Date(Max({1<Month_End_Date={"<=$(Date(vMonthEndSelected))"}>} Month_End_Date,5),'DD MMM YY'))

      AND [Month End Date]<=Date(Date#('$(vMonthEndSelected)','DD MMM YY'))

      ,[Month End Date]

       

      Here vMonthEndSelected=max(Month End Date)

       

      But am unable to to show the latest 5 months of data dynamically.any one can help me where exactly the problem is please.

       

       

       

      Thanks