3 Replies Latest reply: Aug 11, 2010 10:04 AM by Or Shoham RSS

    Help with absolute sum

      HI

      I have a table in qlikview that looks like

      Needed Working Variance

      Tellers 5 4 -0.25

      Enquiries 3 1 -2

      Sales 2 2 0

      needed has =sum(needed)

      working has =sum(working)

      variance = (sum(working)-sum(needed))/sum(Working)

       

      what I need so What I need is to get the absolute sum of the variance as in ABS(-0.25 + -2 + 0) = 2.25

       

      How do I achieve this in qlikview