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 :

       

      Date

      Year

      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?