expression return wrong

[pangalawang]

why this expression below is giving a wrong result:

IF([New Delivery]=TRUE,
ANY(SELECT(DELIVERY[Check Number],
[Timestamp]=
MAX(Select(DELIVERY[Timestamp],[BRANCH]=[_THISROW].[GS BRANCH])))),

Any(Select(Order Details[Check Number],[Timestamp]=MAX(
SELECT(
Order Details[Timestamp],
[Product Name]=[_Thisrow].[Product Name]))
)
))

supposed result is (highlight in yellow)

but it is giving me this instead:

seems something is giving the timestamp off

[Joseph_Seddik]

Welcome to the community!

First, try this:

IF([New Delivery]=TRUE, 
  ANY( SELECT(DELIVERY[Check Number], AND(
         [BRANCH] = [_THISROW].[GS BRANCH],
    [Timestamp] = MAX(DELIVERY[Timestamp])
  ))),
  ANY( SELECT(Order Details[Check Number], AND(
    [Product Name] = [_Thisrow].[Product Name],
    [Timestamp] = MAX(Order Details[Timestamp])
  )))
)

[pangalawang]

Hi,

I Tried, didn't work. It also not get the else condition right.

with max select combo, I was able to get the else condition right, now it doesn't.

I have looked at the Key Values it is getting and the max expression is getting the earliest time of timestamp:

This is a bit confusing. wondering what is throwing the timestamp off.

[Joseph_Seddik]

Hello,

Please show the results of the expression from the expression assistant, and indicate what result you'd expect and how it differs from the expression's result. Thanks

[pangalawang]

I have regenerated and it went Ok. don't know why. thanks anyways.