Use a summary field to sum each field. Perform a find to filter your data then use replace field contents to replace the contect of a field with 1.
That worked for today. Thank you for the suggestion. However, tomorrow, I'll have new data imported. I would like to not have to do a filter and replace daily.
Is there a solution that does not involve this method?
You can create a script to peform the step for you.