2 Replies Latest reply: Mar 6, 2017 4:39 PM by jade wind RSS

    Find records where multiple columns exceed benchmark

    jade wind

      Hi everyone,

       

      I was given a task to show records that have at least three of the specific four fields exceeding their benchmarks.

       

      I have, in the loading script, created columns to indicate the benchmark status of each column needed (refer to attachment). And I am thinking of using script to create a new column to include any possibility of the combinations (when any three of the four fields exceed benchmark, plus when all the four columns exceed benchmark). However I would imagine this last column will be a VERY long script.

       

      Is there any better way of doing this? Basically if any three or all four of these fields is marked as "Over BM xxxx" then they should be marked in the new column as "Risky".

       

      Thanks in advance!