Qty getting doubled while calculating sum

[vireshkolagimat]

Dear All,

I'm calculating sum of qty sold as one exp and sum of qty sold multiplied by packsize in another exp.

But the first exp works fine but second one is not showing the correct values.

I tried to use the distinct in the second exp but still facing issues.

Regards,

Viresh

 

[shiveshsingh]

If you remove item code dimension, then what is the result?

[rubenmarin · Accepted solution]

Hi, as Packsize is a dimension and will have only one value you can try with "Packsize*Sum(SalesQty)" or "Packsize*Column(1)"

[vireshkolagimat]

Hi, i think it works fine but can't show the total even though I've enabled show partial sum option in the presentation tab.

Thank you.

[vireshkolagimat]

Hi, i tried but no changes. Thank you.

[rubenmarin · Accepted solution]

Hi, total fails because of having difrferent values for Packsize, you can set the expression as:
Sum(Aggr(Sum(SalesQty)*Packsize, ProductCode, ItemCode, Packsize))

Or just:
Sum(Aggr(Sum(SalesQty)*Packsize, Packsize)) //does the operation for each Packsize and sums all generated values

[vireshkolagimat]

Hi, I was able to fix it and used the same logic. Thank you.