Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an expression using aggr() that I'm struggling with. I'm trying to show Extended Avg Selling Price (Quantity* Avg Selling Price) for CM supplier using a Pivot table. But the total value is not being summed up correctly.
The expression I've used is
if(Match(Dimensionality( ),0,1,2), sum(aggr(sum(Quantity)*[Avg Selling Price],[Purchase Order])), sum(Quantity)*[Avg Selling Price])
I appreciate any help... Thanks!
Try
SUM(Quantity * [Avg Selling Price])
instead of
sum(Quantity)*[Avg Selling Price])
Try
SUM(Quantity * [Avg Selling Price])
instead of
sum(Quantity)*[Avg Selling Price])
May be:
if(Match(Dimensionality( ),0,1,2), sum(aggr(sum(Quantity)*Only([Avg Selling Price]),[Purchase Order])), sum(Quantity)*Only([Avg Selling Price]))
Thank you. It's working as expected.