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?