JIRA Structure Formula field is not calculating the IF condition properly for Progress & RAG status

[Yatiraj Sharma]

I am using simple formula using IF function in my JIRA structure, however, It is not properly calculating IF condition and Progress column and always putting it as "Red" which is default value.  

IF( Progress > = 70; "Green"; "Red") 

[Yatiraj Sharma · Accepted solution]

We have to use the below formula like this

IF(Progress > 0.7, "{panel:bgColor=#59B161}Green{panel}", Progress > 0.5, "{panel:bgColor=#FFAF00}Orange{panel}", "{panel:bgColor=#EF4B59}Red{panel}")