I'm trying to make a composite column to display the "Reading Status" based on the actual value of a column "%percent read".
I can use the following to set to 'Complete' if %percent read" is set to 100
Code:
{:'cmp(field('#kobo_percent_read'),100,'','Finished','Finished')'}
I want to change this to set to reading if the value is between 1 and 99 and unread if 0 or blank
Can this be done?