2 Replies Latest reply on Oct 7, 2016 2:19 AM by jason martin

    Multiple variables overall calculation

    jason martin

      Hello,

       

      I have a situation that I am having trouble with.  I have created a bunch of calculated fields (13) that all return "Green", "Yellow", "Red" or "Gray".  I want an overall calculation that looks at all the variables and returns an over all color.

      Logic is "If any variable is Red then Red", "If all of the variables are either Green or Grey then Green", "if no variables are "Red" and any are "Yellow" then "Yellow"

       

      Anyone have ideas?  Thanks