2 Replies Latest reply: Oct 27, 2015 10:30 AM by Sunny Talwar RSS

    Condition differently in the Set analysis

    Andrea Masciulli

      Goodmorning everyone

      I need to enter in a formula by Set analisys to select data other than a given value

      the syntax that normally use to control "if equal" is sum ({$ <[Flg Activity Type] = {'F'}>} [Total power consumption in ])

      but if I have to select data other than F does not work the formula

      sum ({$ <[Flg Activity Type] <> {'F'}>} [Total power consumption in ])

      someone would know how to say it uses the Set analysis on the condition differently?

      Thank you

      Andrea