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

    Is not equal to...

    Simon Brulotte


      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...