2 Replies Latest reply: Oct 19, 2010 4:38 AM by shanejvv RSS

    Sum and Division

      Hi,

      I'm trying to Sum column A and divide the total by column B but my expression is not giving me the correct total.

      My expression is:

      ************************************************************************************************************************************

      sum({<Registration_Code={'2'}, Vehicle_Status = {'Normal'}, Contract_Prefix={'A'},YMDate = DisplayYM>} [Total_proceeds])

      /

      sum({<Registration_Code={'2'}, Vehicle_Status = {'Normal'}, Contract_Prefix={'A'},YMDate = DisplayYM>} Market_Value)

      ************************************************************************************************************************************

      When I add Total_proceeds in Excel and divide it by the sum of Market_Value, I get 46.74% but qlikview is showing 51.74%.

      Is there something wrong with the expression or should the expression be totally different?

      tx,

      S