MIN and MAX ref rows are displaying incorrect data

Hello,

I have an expression that pulls the information from a child table, The info i'm getting is the MIN Time for a collumn and the MAX time for another collumn :

 

CONCATENATE(
MIN(SELECT(Route[Route_TimeUp], [RDV ID] = [_THISROW].[RDV ID]))," - ",
MAX(SELECT(Route[Route_TimeDown], [RDV ID] = [_THISROW].[RDV ID]))
)

 

This expression was working flawlessly but lately a user pointed to me that it displays incorrectly, it's very weird too because during each re-sync, I get new data, wrong data I might add. In the editor, if I inspect the expression, every single one I check is correct. So I'm at a loss now, AppSheet bug ?? 

464398348_1869217370236205_1933052878078120443_n.gifCapture dโ€™รฉcran 2024-10-22 095333.png

 

Let me know if you can help !

PS I should add that I have a LOT of data in both the parent table and in the child one, I don't think it should be a problem as the SELECT() expression narrows it down quite well

0 1 114
1 REPLY 1

Steve
Platinum 5
Platinum 5

Likely related to the problem reported here. Please contact AppSheet Support for help with this.

Top Labels in this Space