select the correct fields and values. Don't select a field. Invalid value

[Sxbbb]

Retest : 

(Sum( 

{$<DATE={">=$(=max(Date_Start))"}, Day=, Month=, Year=>}
[RE-TEST]))

Select FX_FixtureID ='20220282'

Results :

But if FX_FixtureID is not selected, the value is wrong. 

Table RetestReport 

Load FX_FixtureID ,
         DATE,
         DATE_ARRAY,
         KEY_ARY  

FROM [source];
Table Retest 
Load  KEY_ARY  ,
          Retest 
FROM [source];
Table Header 
     Load  FX_FixtureID  ,
                Date(if(IsNull(ET_StartDatetime) ,Date(ET_CreateDate),Date (ET_StartDatetime))) as   Date_Start
FROM [source];         

The problem I encountered was that I had to select FX_FixtureID to make =max(Date_Start) display. What should I do?

[lennart_mo]

Hi @Sxbbb,

i think what may help you in this case is creating a field with the max(Date_Start) for each FixtureID rather than using the function in the set analysis, since this should give you the max Date_Start for all FixtureIDs.

So an option would be an addition to your script like

Left Join(Table Header)
Load
FX_FixtureID,
Max(Date_Start) as Max_Date_Start
Resident Table Header
Group By FX_FixtureID;

 and adjusting your set analysis to

{$<DATE={">=Max_Date_Start"}, Day=, Month=, Year=>}

 Let me know if this works for you!