6 Replies Latest reply: Dec 13, 2017 9:27 AM by Tom Müller RSS

    Exclude fields, that don't have specific value

    Tom Müller

      Hi all together,

       

      I have an excel sheet, that looks like this:

       

      ProjectValueCosts
      1100005000
      22000012000
      33200015000
      62000

      32000

       

      I load the file directly as an excel file, so I don't use the data editor.

      I want to exlude from all evaluations the projects, that don't have a Number (so in my example row 4).

       

      I thought about using if (len(Project)=1), ....

      but if this would work I don't know how to go on. But maybe there is a better way, you could tell me.

       

      Thanks for the replies,

       

      Tom