'If' statement help

Comments

3 comments

  • Nate Bennett

    Hi Hannah,

    You do need to reference at least one other field. Are you sure the calculation is referencing the Inherent Rating Score field? The text will be highlighted in blue if it is.

    0
    Comment actions Permalink
  • Rainer Grabowski

    Hi Hannah,

    as Nate wrote, the field `@Inherent_Rating_Score ' must be highlighted blue (enter @inherent and select the field from the dropdown list).
    Besides that: I think your code wouldn't work for several reasons: You can try this one:

    var IRS = @Inherent_Rating_Score;
    var  Inherent_Rating_Category = IRS < 7 ? "Low" : IRS < 16 ? "Medium" : "High"
    
    Inherent_Rating_Category
    

    Rainer

    0
    Comment actions Permalink
  • Hannah Durrant

    Hi Nate and Rainer,

    Thanks so much for your help! Rainer, that worked brilliantly, thank you! :-)

    Hannah

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk