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

[Sxbbb]

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

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. 

Want the correct value displayed Even if FX_FixtureID is not selected

[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. 

Want the correct value displayed Even if FX_FixtureID is not selected

[anat]

Can you share your data with date field

[rubenmarin]

Hi, you can try adding the expression to a table without expression titile, so you can see how it's transforming =max(Date_Start), and confirm how it works when there is no FX_FixtureID, maybe it's returning something unexpected.

Or maybe it's becasuse of the format of DATE field.

[Sxbbb]

Table Retest 

Load FX_FixtureID ,
         DATE,
         DATE_ARRAY,
         KEY_ARY  

Table Retest 
Load  KEY_ARY  ,
          Retest 

Table Header 
     Load  FX_FixtureID  ,
                Date(if(IsNull(ET_StartDatetime) ,Date(ET_CreateDate),Date (ET_StartDatetime))) as   Date_Start,
         
The problem I encountered was that I had to select FX_FixtureID to make =max(Date_Start) display. What should I do?

[Sxbbb]

*** Table RetestReport

Load FX_FixtureID ,
         DATE,
         DATE_ARRAY,
         KEY_ARY  

[Sxbbb]

@rubenmarin @anat