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?