1 Reply Latest reply: Feb 9, 2018 2:51 PM by Digvijay Singh RSS

    Difference in summed values

    scott dealtrey

      Hi, I am trying to do some calculations of some GL codes, but I am getting different values depending on how I write the function.

       

      The two ways I was writing the function are as follows -

       

      sum({<GL_NBR={'*90115-*','*90210-*','*90220-*','*90225-*','*90230-*'}>} "GL_BAL_01" + "GL_BAL_02")

       

      versus

       

      sum({<GL_NBR={'*90115-*','*90210-*','*90220-*','*90225-*','*90230-*'}>} "GL_BAL_01")

      +

      sum({<GL_NBR={'*90115-*','*90210-*','*90220-*','*90225-*','*90230-*'}>} "GL_BAL_02")


      The latter provides the correct value and there is a distinct difference in the returned value. Is this something to do with my data set? I would assume there would be no difference between the two calculations?


      Thanks