InYearToDate function gives wrong values

Fri, 17 Jul 2009 19:10:52 GMT

I have a really strange problem with the InYearToDate function. Given the following situation:

LET vCurrentDate = '31-03-2008 23:59:59';

When I do a sum(Sales) over the year 2008 (jan, feb, mar) I get as result: € 257.203,00 which is right.

When I do a sum(Sales) over the year 2007 (jan, feb, mar) I get as result: € 243.214,00 which is also right.

Next thing I want to do is a YearToDate function to compare with 2007 (jan, feb, mar). To sum 2007 and 2008 sales I use the following syntax:

to sum 2008:

Sum({1} IF(InYearToDate (Date, vCurrentDate , -0), Sales))

to sum 2007:

Sum({1} IF(InYearToDate (Date, vCurrentDate , -0), Sales))

The values I get back from those two functions are:

I really don't know what's going wrong.. any sugestions?

Fri, 17 Jul 2009 19:13:25 GMT

Of course to sum 2007 should be:

Sum({1} IF(InYearToDate (Date, vCurrentDate , -1), Sales)

Fri, 17 Jul 2009 19:27:31 GMT

Stupid mistake..... I forgot a field in my link table which caused the strange values.

topic InYearToDate function gives wrong values in QlikView