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

[kaushiknsolanki]

Hi,

     Try this.

     sum({<dealdate={">=$(=date(min(INDATE)))<=$(=date($(E)+40))"}>} qty)

Regards,

Kaushik Solanki

[its_anandrjs]

Try to remove equal sign

Sum({<dealdate={">=$(date(INDATE)) <=$(date($(E)+40))"}>} qty)

[#4]

the problem is that the three row  is the same value 2014/01/01, It is three value

[#5]

I cann't work

[kaushiknsolanki]

Dear Jack,

     Kindly explain in Detail, if possible with exmaple

Regards,

Kaushik Solanki

[#7]

I have attached a sample.qvw . I want to get sum for different indate

[kaushiknsolanki]

Dear Jack,

     Apologies, but i am still not getting what you are looking for.

Regards,

Kaushik Solanki

[#9]

COMPANY	ITEM	INDATE	sum({<dealdate={">=-<=2014/3/13"}>} qty)
A	11	2014/1/1	30
A	12	2014/1/2	10
A	13	2014/1/3	20
B	12	2014/1/2	20
B	15	2014/1/5	0
B	17	2014/1/7	0
B	21	2014/1/1	0
C	14	2014/1/4	20
C	16	2014/1/6	30
C	18	2014/1/8	0
C	19	2014/1/9	0

this is a sample results . for COMANY  A &  ITEM 11 ---  I should sum qty from 2014/1/1--- 2014/03/13 , for A&12  I sum  from 2014/1/2--- 2014/03/13,

etc . If use min as you suggest  , all company &item  sum qty from 2014/1/1--2014/03/13

[kaushiknsolanki]

Hi,

     So in short you need cumulative values?

Regards,

Kaushik Solanki