Sum() operation in Scripting

[markgraham123]

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.

[alexandros17]

very strange, can you share your original app?

[settu_periasamy]

Hi,

A,B  is a field name or data?

if you post the good example in excel or qvw, we can try to find the solution

[#4]

Hi,

Can't you add Name and place as dimensions as below to get the result!

[markgraham123]

Hi,

I did it in the front end, it worked.

Thank you very much.

[markgraham123]

Thanq kiru devi.

[markgraham123]

Thanq Rudolf

[markgraham123]

Thanq periasamy.