Skip to main content

Help with a Formula

  • January 29, 2024
  • 1 reply
  • 16 views

Forum|alt.badge.img

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

seferiannie
Forum|alt.badge.img+5
  • Participating Frequently
  • April 1, 2024

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