I am trying to have a progress bar that displays the completeness of a users profile, similar to linkedin. I have 17 data field that are a mix of text, y/n’s and numbers. In the screenshot below I have the when X is not empty format to a number 1 yes 0 no. The system is not calculating that formula for some reason.
In a different area, I have the same exact concept accept all 13 of the data fields are y/n’s and it is calculating perfectly.
Any thoughts?


