Survey123 if statement calculation

[ChristopherMask]

Good Morning Community,

Again, I know this shouldn't be hard, but I can't get the calculation to work using an if statement. Could someone help with the name columns Two09 and Two09Calc. It currently has this for the calculation:

if(${FinalFireAcreQuantity}>='300','Yes','No') 

Also, I would like to add a condition for NumberFatalities >=1 to the if statement. 

If statement is true, then Two09 = Yes, if not Two09 = No.

[Katie_Clark · Accepted solution]

I think the issue might be that you are trying to use a comparison operator ( >= ) on a string ( '300' ). What is the field type of ${FinalFireAcreQuantity}? If it's a number type, try removing the quotes around 300 and see if that works. 

[ChristopherMask]

Goodness, that worked! Thanks for the response and have an excellent weekend!

Also, added more to the statement. if((${FinalFireAcreQuantity}>=300 or ${NumberFatalities} >=1), 'Yes','No')

Christopher

[PavlovaVitale]

on what type of column do you put the if statements?

[Katie_Clark]

@PavlovaVitale In a case like this, it should go in the Calculate column