16 Replies Latest reply: Aug 31, 2015 2:54 PM by Mark Graham RSS

    Sum() operation in Scripting

    Mark Graham

      Hi all,

       

      I was working on a requirement where i have to count the Sum(Units Sold) per Name and per Place.

       

      So, i did Sum(Units Sold) group by Name , Place in the script and loaded it as a dimension.

       

      It worked but the problem is ..

      Eg:

      when the units sold is only one value i.e. 10 for Name A - Its not getting counted,

      where as if the units were 10 and 5 its getting counted as 15.

       

      Can anyone help me on this.