Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have source file like this,
ID | NAMES | SAL | YEAR |
111 | RAJ | 10000 | 10/10/2001 |
222 | RAJA | 20000 | 2/20/2002 |
333 | SRI | 30000 | 11/25/2003 |
444 | NANDU | 60000 | 3/30/2004 |
555 | SAI | 70000 | 5/5/2016 |
I am tryingto acheive YTD but i am not getting .
Dimension :- Year
Expression:- sum({<YEAR={">=$(=YearStart(=Today()))<=(=Today())"}>}SAL)
sum({<YEAR={">=$(=YearStart(Today()))<=$(=Today())"}>}SAL)
or
sum({<YEAR={">=$(=YearStart(max(YEAR)))<=$(=max(YEAR))"}>}SAL)
sum({<YEAR={">=$(=YearStart(Today()))<=$(=Today())"}>}SAL)
or
sum({<YEAR={">=$(=YearStart(max(YEAR)))<=$(=max(YEAR))"}>}SAL)
Hi Kushal,
Thanks,I got It.
Regards,
Mahesh
Try like this
sum({<YEAR={">=$(=YearStart(Today()))<=$(=Today())"}>}SAL)
Not a problem
Hi,
Thanks, Avinash
Regards,
Mahesh
np problem