3 Replies Latest reply on Apr 22, 2018 9:56 PM by Eric Hammond

    Calculated field: if header contains X then add the values of the columns

    Numa Roch

      Hi,

       

      I have a file with dozens of columns the values of which I want to have summed up in a separate calculated field.

       

      Rule: if header title contains "COMP" and does not contain "CHALLENGE" then add the values on the record level (i.e. for each row).

       

      RM COMP 1
      RM COMP 2RM COMP 3RM COMP CHALLENGE
      CALCULATED FIELD: add values if header contains "COMP" and does not contain "CHALLENGE"
      036209
      101020540

       

      The header titles in the source file might change as they get refreshed, the only stable variables are "COMP" and "CHALLENGE", so creating an endless list X+Y+Z+etc... like the one below won't do.

      Endless list X plus Y plus Z etc.png

       

      Any idea? Many thanks in advance.