Expression help

[#1]

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

[sunny_talwar · Accepted solution]

May be using this:

Sum({<INVDATE = {"$(='>=' &TimeStamp(SetDateYear(YearStart(Today()), Max(Year))) & '<=' & TimeStamp(SetDateYear(Today(), Max(Year))))"}>}NETTOTAL)

[Clever_Anjos]

wow, never heard about SetDateYear() function.

Today is a great day for learning stalwar1‌

[sunny_talwar]

I recently got to learn that from swuehl‌‌ (like may be 2-3 days ago)

[Clever_Anjos]

swuehl‌ is a Jedi Master with midichlorians level very high

[#6]

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