Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have an issue as i want to get values such that when i select year the value should get the values from 1-1-of selected year till 3-9-selected year means date of today but year is the selected year . Plz help it is urgent.
Thanks in advance
Ferha Jafri
Hey, i had to do something similar to analyze this year vs last year on the same period.
=sum( {1< YEAR={$(=(num(Year(TODAY()))))}, PERIOD_NUM= {'>=1<= $(=(num(Month(Today())-1)))'}> }PERIOD_ACTIVITY)
Try to adapt the code to your case adding a set analysis also for day
p.s. Period num is my Month Field