8 Replies Latest reply: Jan 15, 2014 1:27 PM by Simon Brulotte RSS

    Is not equal to...

    Simon Brulotte

      Hi,

      here is a simple dimension definition in a straight table:

       

      = if(FABS(%CR003M)<>1,[Poste budgétaire])

       

      It's suppose to see if the absolute value of %CR003M is not equal to 1, and bring back the culprit Poste Budgétaire.

      FABS(%CR003M) = 1 works well, but not the <> .

       

      What could I be doing wrong? This sounded so simple to me...