FORMULA

[#1]

as sample , I write  sum({<dealdate={">=$(=date(INDATE))<=$(=date($(E)+40))"}>} qty), the indate is a fields .  I can't get right answer for different indate

[#2]

Finaly, I want to get the sum  from company &item 's beginning date.

[kaushiknsolanki]

Hi,

    Check the attachment, i hope this is what you want.

Regards,

Kaushik Solanki

[#4]

I don't need cumulative.

COMPANY	ITEM	INDATE
A	11	2014/1/1
B	12	2014/1/2

there are many deal data for company &item in different date .

finaly:

first row : I want to sum qty from 2014/01/01---  defined date.

second rom: I want to sum qty from 2014/01/02---  defined date.-----   pay attention: is 01/02 not 01/01

[#5]

it means  sum({<dealdate={">=$(=$(INDATE))<='2014/5/1'"}>} qty) don't work----  I can't get the INDATE for each item.. 

[kaushiknsolanki · Accepted solution]

Hi,

     Its not possible to get the different date for each record in set analysis.

     You will have to think about some other logic to achieve this.

Regards,

Kaushik Solanki