First sorted value Time

[#1]

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?

[sunny_talwar]

May be you need this:

FirstSortedValue({<SettlementTime={"$(='<' & Time('08:00:00:000000', 'hh:mm:ss:ffffff'))"}>} RunningBalance,-SettlementTime)

[sunny_talwar]

What format is is SettlementTime? Just make sure it is in hh:mm:ss:ffffff