Sum() operation is returning total sum by default

[markgraham123]

Hi Everyone,

I'm working on an application, where when i select SKU#, it should show the Warehouse in the chart table and individual sum.

In the end, i have to see the total.

But the total sum is getting populated in all the Sum() fields rather than its own individual sum() values.

PLease look into this.

[sorrakis01]

Hi,

In expression  write Sum(Aggr(Sum([Qty on Hand]),[ID Warehouse]))

Regards,

[markgraham123]

HI,

The expr. is returning zero values.

[sorrakis01]

Hi,

See the example.

Regards

[markgraham123]

HI,

Please find the app. with updated data..

its not working in the below app.

sorry for inconvenience.

[sorrakis01]

Hi Mark,

For understand your problem... your problem exactly is on Total of Simple Chart? now its correctly. In your first example only sums distinct values. And now sum all values.

Maybe the problem it's on your values because you have a Qty 44 on a null dimension.

For understand, where is your problem exactly?

if you prefer you can upload Book1.xls

Thanks

[markgraham123]

I want to sum only distinct values but not total values....

[sorrakis01]

Hi,

ok and this?

Sum(DISTINCT Aggr(Sum([Qty on Hand]),[ID Warehouse]))

[markgraham123]

Hi,

it still shows the total .

[awhitfield]

Hi Mark,

Should the dimension be Skort_Warehouse  and expression just sum(qty on hand)

HTH - Andy