2 Replies Latest reply: Jun 19, 2012 5:15 PM by Andreas Hornich RSS

    Strange behaviour when sum "<" vs. ">"

    Andreas Hornich

      Dear All,

      i found a rather strange behaviour when trying to sum values based on a if < vs. if >


      I am trying to visulize the +/- deviance per month(y) compared to a fixed month(x).


      So i basically build two columns per year if(x<y,sum(x-y)) / if(x>y, sum(x-y)).

      The problem is the QV does not sum the if(x>y, sum(x-y)).


      Is this a bug? I can't see any reason why no sum is shown for this expression. I tried to show this in the attached QVW.


      I'd appreciate if you'd have a look at it!


      Thank you