Incorrect expression using set analysis

[maoros]

Hi everyone,

I have a problem with a set analysis expression and I didn't identify which is the error.

Suppose we have the following data.

For the date 01/11/2019, I want to get the expect value equals to 0.

For 01/12/2019, Expected value = 0

For 01/01/2020, Expected value = 10

For 01/02/2020, Expected value = 11

For 01/03/2020, Expected value = 14

and so on.

That is,

However, I get 0's when I am using the following set analysis expression:
=Sum({< TheDate={">=$(=MonthStart(AddMonths(TheDate,-2)))<=$(=MonthEnd(AddMonths(TheDate,-2)))"} >} Actual)

But it is not correct because I get 0's and I didn't find which is my error.

Any ideas?

I include the qvw file used (ValueForSpecificDate.qvw).

I really appreciate your help.

--- maoh

[Kushal_Chawda · Accepted solution]

Probably you need this

=sum(aggr(above(sum({<TheDate>}Actual),2),TheDate))*avg(1)

[maoros]

Thank you. It works!