I believe I have a fairly straight forward nested 'if' statement here, but I'm missing something as I keep receiving errors. Any help would be appreciated. Thanks! Any thoughts James Tedrick?
Here is the expression within a calculate field type. The field name is {risk_rating_calculate}:
if(${percent_rating}>=80,'SUSTAINABLE', if(${percent_rating}<80 and >=50,'AT RISK', if(${percent_rating}<50,'NOT SUSTAINABLE','')))
The error being thrown is this:
{percent_rating} is an integer field that references a previous calculate expression (see attachment screenshot).
Thanks in advance!
-Corey