Table result error

[#1]

When I select the below criteria individually the results are OK. Attached is the QVD file.

First Criteria                                                         Second Criteria     

But when I combine the selection, some of the result is wrong : e.g. the OMSPO# 00012800’s FStatusDate is 03/12/2015, but it supposed to be 04/12/2015 if you execute the first criteria.(which is correct) .Thank you.

Appreciate someone could help.

Regards,

AG.

[ramasaisaksoft]

Hi Andros,

in your attachment qvw file Test tab  what you want in Chart?

Once u select the Track mode as BookCNFRE then it is giving different results means may be you don't have data for that Track mode or else you need to change your expressions according to that selection also.

[swuehl]

I can't see OMSPO# 00012800 in your test date, I can see OMSPO# 128000 with a status date 25/01/2016 though.

Not sure how I can tell what's right and what's wrong. You would need to tell us a little more about your requirements.

[imrencimen]

OMSPO# is "000012800"

Your Expression is ;

=MIN(StatusDate)

İf u select all Track kode

min status date=03/12/2015.

OMSPO#	StatusDate	StatusDateF	trackCode
000012800	03/12/2015	03/12/2015	BOOKED
000012800	04/12/2015	03/12/2015	BOOKCONFRE

[#5]

Hi imren,

Not the BOOKCONFRE captured 03/12/2015 as it captured 03/12/2015 as the MIN statusDate.

I think I know the problem, the criteria should be :

1. PO with Trackcode : BOOKED  linked to TransportMode : B & V only
2. PO with TrackCode :  BOOKCONFRE linked to TranspoprtMode : S, C, P, T only

3. Basically I need 3 reports : BOOKED, BOOKED and Combination of BOOKED & BOOKCONFRE.

4. But Currently, I can generate 2 separate reports (select BOOKED, B,V  Or BOOKCONFRE, S,C,P,T) but not both as BOOKCONFRE also has TransportMode B & V in which I should exclude from the report.

5. And in each PO, they have multiple dates and I should take the first StatusDate (MIN(statusDate).

So how should I change the script to se the 2 cateria ?

Appreciate your help.

Thank you.

Regards,

AG