## Activity 17 - Headcount formula

SOLVED
Occasional Contributor

## Activity 17 - Headcount formula

I'm doing trying to write the headcount formula for the Rep Quota module, and the video says it should be straightforwardly deliver a 1 if the Rep has a quota, so I assume this needs to be 'IF XXX THEN 1 ELSE 0' but when I input 'IF Quota THEN 1 ELSE 0' I get an error message that says that this formula requires a Boolean, which obviously Quota does not have.

What am I doing wrong? (Screenshot attached)

Message 1 of 3
2 REPLIES 2
Community Boss

## Re: Activity 17 - Headcount formula

Hi,

If quota has number format this will not work so instead you could do 'IF Quota>0 then 1 ELSE 0'. As the 'IF' formula requires a logic answer like true to function.

I hope this helps and if you have anymore questions please do let me know.

Thanks,

Usman

Message 2 of 3
Occasional Contributor

## Re: Activity 17 - Headcount formula

Thanks for the quick response, Usman! That makes sense. I'll give it a go and see if it gives what  it's meant to once everything else is filled in!

Message 3 of 3