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.
What you are doing should work just fine, so I’d suggest making use of the debugger here. You can drill down to each of these items and see what each one is evaluating to…takes the guess work out of things.
