topic select the correct fields and values. Don't select a field. Invalid value in App Development

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

Sxbbb — Fri, 15 Nov 2024 20:54:45 GMT

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?

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

lennart_mo — Wed, 17 Jul 2024 08:41:10 GMT

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!