There is a table where information is entered every day, and there is a Choice field - categories. When we open a new day, it is necessary that the value of the categories is transferred to the next day. How we can do this? For such cases we use the formula

let c := number(Id);
let bc := last((select 'Daily Result' where number(Id) < c) order by number(Id));
first(select 'Daily Result' where Id = bc).Category

It doesn't work for the Choice field. Tell us please the correct formula for trigger choice field

Regards