About PatM

PatM · 10-20-2020

Hello, This is slight variation of the solution already answered in https://community.appsheet.com/t/slice-by-latest-date/28435 Trying to create a slice that is filtered based on latest date. Example given below where the golfer with the latest date ...

PatM · 07-27-2020

Hello, Trying to create a slice that is filtered based on latest date. Example given below where the golfer with the latest date is returned (i.e. ID 3 is removed from the slice) Data ID GolferID Type Hcap Date 1 1 GUI 16 29/06/2020 2 2 GUI 12 29/06/...

PatM · 10-20-2020

Steve: ISBLANK( FILTER( "HcapGUI", AND( ([GolferID] = [_THISROW].[GolferID]), ([Hcap Date] > [_THISROW].[Hcap Date]) ) ) ) Thank you Sir Steve Isaiah 42:7 To open the eyes that are blind, to bring out the prisoners from the dungeon, from the prison t...

PatM · 07-27-2020

Thank you very much. Worked first time

PatM · 07-27-2020

Thanks Steve, tried a few examples to get this to work but failing miserably LOOKUP( MAX( SELECT( HcapGUI[_ROWNUMBER], ([_THISROW].[Date] = [Date]) ) ), “HcapGUI”, “_ROWNUMBER”, “HcapID” ) The expression is valid but its result type ‘Ref’ is not one ...

My Stats

PatM's Bio

Badges PatM Earned

Recent Activity

Slice by latest date (Part II)

Slice by latest date

Re: Slice by latest date (Part II)

Re: Slice by latest date

Re: Slice by latest date