Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi expert ,
I have data from 2009 Jan to 2013 Apr.
I want to calculate YTD means if i select 2012 it show brand wise nettotal from 1st jan 2012 to 11th may 2012.
similarly if i select 2011 it shold show net total from 1st jan 2011 to 11th may 2011.
I have attached the sample .qwv file and please help me writing expression.
Best Regards
Tripati
May be using this:
Sum({<INVDATE = {"$(='>=' &TimeStamp(SetDateYear(YearStart(Today()), Max(Year))) & '<=' & TimeStamp(SetDateYear(Today(), Max(Year))))"}>}NETTOTAL)
May be using this:
Sum({<INVDATE = {"$(='>=' &TimeStamp(SetDateYear(YearStart(Today()), Max(Year))) & '<=' & TimeStamp(SetDateYear(Today(), Max(Year))))"}>}NETTOTAL)
wow, never heard about SetDateYear() function.
Today is a great day for learning stalwar1
I recently got to learn that from swuehl (like may be 2-3 days ago)
swuehl is a Jedi Master with midichlorians level very high
Hi Sunny
Expression is working fine.
Thanks a lot.
Just want to know what is the use of concatenating operator and Setdateyear function.
Best Regards
Tripati