5 Replies Latest reply: Aug 10, 2016 1:04 AM by jade wind RSS

    Set analysis - not a number

    jade wind

      Hi everyone,

       

      How can I put the condition of "not a number" in a set analysis expression? For example: in below set analysis expression where all Employee IDs are included, I want to change it to only where the Employee ID is not a number (or is a number then I can work out the other way round). (Where the Employee ID is not a number, the values can be a string or blank or some symbols. )

       

      sum({$<[Employee ID]={"*"}>}[Total Net paid])

       

      Any suggestions?