the date is wrong

[#1]

I have get the table as the following . I get E from C & D , but the $(E) is the same value . It should DEALDATE>='20140101'  for A &B company and '20140401' for company C . It get the same '20140401' value.  How to do it  ?

A	B	C	D	E	F
COMPANY	ITEM	INDATE	min({<DEALDATE={'<=ENDDATE>=STARTDATE'}>}DEALDATE)	if(IsNull(D),INDATE,D)	sum({<DEALDATE={">=$(E)"}>} QTY)
A	2PU82561204	20140101		20140101	5
B	2PU82561204	20140101		20140101	6
C	2PU82561204	20140101	20140401	20140401	7

[MK_QSL]

Didn't understand your question.

Can you please elaborate little more?

[#3]

Hi,

I think your set definition for D should have double quotes instead of simple ones: {"<=ENDDATE>=STARTDATE"}

Otherwise, some sample data would help for the answer.

[preminqlik]

can you please elaborate more ?.....because where is deal date ?....

[#5]

A,B,C  column  is raw data .  D  column is the formula value  . I get E column from D column(for test ) . The F column is what I want to get . But the  F  column  is wrong because it get the same date   for company A,B,C  .  It should are different value for different company.

[#6]

for example , company A have many dealdate  for one item . the indate is only value for company&item. The startdate and enddate is input date scope. I want to sum the QTY  starting from E COLUMN DATE . I set D &E COLUMN as variables.

[anbu1984]

Can you provide sample data?

[#8]

Dear Jack he,

You can use the below script in scripting.@@@@

Date(right(INDATE,2)&'/'&mid(INDATE,5,2)&'/'&left(INDATE,4),'DD/MM/YYYY')

Please find the attachment.

Regards,

Shrikanth H Koppad

[#9]

the sample is as attached.

[#10]

sample file