0 Replies Latest reply: Sep 17, 2017 6:40 AM by Mohammad Adnan Ansari RSS

    Set Analysis - YTD sales for current Hijri Year

    Mohammad Adnan Ansari

      I have a master calendar which has the below values :




      Month Year

      Hijri Date

      Hijri Year

      Hijri Month Year


      I can calculate the current year sales as below:


      Sum({$<[Date] = {"<=$(=Today()-1)"},[Year]={"$(=Year(Today()))"}  [Sales])

      I have a requirement to produce current Hijri Year sales. How can i write a similar set analysis function as above for it?