5 Replies Latest reply: Feb 3, 2016 12:36 AM by Yomna Touni RSS

    load is giving me incorrect values

      Hi All,

      I'm still stuck with the same function I had attempted to get fixed in the below link.

      I changed the function to include the where clause. but unfortunately its still giving me the same unwanted distinct values that i'm after.

       

      what can I do to get this fixed.

       

      so I've got a sum with a group by clause (which should be the only way to get this correctly done), the sum should be around for example 9828.13 and the actual sum is 157250.08.

      what a friend helped discover was that the big number was in fact an exact multiple of the original number.

      but how this came about is still bugging me.

       

      I've been on this problem for days now.

       

      and I still cant figure it out.

       

      i'd really appreciate some help.

       

       

       

      Group By multiple fields