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

       

      BR

      Andreas