Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The below conversion results in the below time format: 07:00:04:100000
Time(round([Settlement timestamp], 1/8640000 ), 'hh:mm:ss:ffffff') as SettlementTime
However when I try to find the last corresponding balance before 08:00 (as per below) Im getting null values.
The same methodology works perfect when my time format is hh:mm:ss
FirstSortedValue({<SettlementTime={'<08:00:00:000000'}>} RunningBalance,-SettlementTime)
any ideas?
May be you need this:
FirstSortedValue({<SettlementTime={"$(='<' & Time('08:00:00:000000', 'hh:mm:ss:ffffff'))"}>} RunningBalance,-SettlementTime)
What format is is SettlementTime? Just make sure it is in hh:mm:ss:ffffff