5 Replies Latest reply: May 18, 2010 6:25 PM by sergfrac

# Sum with InYearToDate

Dear guys,

I'm not able to solve an issue related a sum with InYearToDate

Firstly, the data I use are included in the year I'm analyzing so the 2 expressions below should give me the same result :

1) sum(var)

2) sum(if(InYearToDate (InvoiceDate.......... ),var)

but looking to attached file u will see for both expression different result.

In case of 2) it duplicate the values. Using DISTINCT solve the example I've but create problem in other case where the dimension I've to use give back just one row.

I've created just a fast example, that I attach, of the issue I have in my production environment

Sergio

• ###### Sum with InYearToDate

Dear All,

Does anyone have an idea about it ?!

Sergio

• ###### Sum with InYearToDate

I have used following set analysis expression which gives me same result.

`sum({<"=\$(year(InvoiceDate))"="=\$(year('2010-05-17'))">} KZWI3)`

• ###### Sum with InYearToDate

I have used following set analysis expression which gives me same result.

`sum({<"=\$(year(InvoiceDate))"="=\$(year('2010-05-17'))">} KZWI3)`

• ###### Sum with InYearToDate

I have used following set analysis expression which gives me same result.

`sum({<"=\$(year(InvoiceDate))"="=\$(year('2010-05-17'))">} KZWI3)`

• ###### Sum with InYearToDate

Dear Devang,

Thanks for your answer and it works in this case, but in my original report I've 2 column

One for this year Sales, the other one for year-1 Sales.

That's the reason why I used InYearToDate function that gives me 2010 sales till today, compare to 2009 sales till the same day of previous year.

How do I get the same using the Set Analysis ? 'Cause your selection above works fine just for the example, but If I had to use the same with 2 columns for different year I don't understand why InYearToDate function give me back data duplicated.

Thanks

Sergio