Help with a Formula

Topic Labels: Formulas
304 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Good Day,


I need assistance with a formula, I would like to count the status of registered learners for a specific project. I tried the Counta formula but the numbers does not add up correctly. It shows for example 2 learners registered against the project code, but none of the learners are registered yet, therefor should show 0?


COUNTA({Learner registration status},"Registered")


1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

delete those empty lines which are auto-populated in the form / project. the formula is correct