Hi,

I'm trying to create an index with the balance in descending order (first by time, then by balance). I can not figure this out.

I tried this expression, but it's not working and I don't see why

index on IIF(cStatus='PAYMENT ARRANGEMENT BROKEN','0','1') + DTOS(TTOD(tScheduleTime)) + ;
*PADL(99999999999999 - yBalance,14,'0') tag tSchedule FOR !DELETED()

Thanks.