Straight table expression to multiply.

[bnelson111]

Everyone this is a strange one that should be simple however i cant get the desired result. See below i have used the expression as the labels on the straight table and table box to try and explain.

Okay basically the sum of the confirmedshippedqty is working but when i try to multiply by the itemtableAREALABEL the expression is null. It works when single items are selected.

Working when single item selected.

Hope this makes sense. Thanks Brett

[kaushiknsolanki]

Hi,

Try this expression.

Sum(ConfirmedShippedQty * [Item Table.AREALABEL])

Or

Sum(ConfirmedShippedQty) * Sum([Item Table.AREALABEL])

Regards,

Kaushik Solanki

[Anonymous]

try

* sum(temtableAREALABE)

could be because they are at different granular levels..

[bnelson111]

The expression is perfect but once i remove a dimension the sum changes see below.

Correct 9,664,320

Remove Linkitemcode dimension

calculation is sum((ConfirmedShippedQty)) * Sum([Item Table.AREALABEL])

dont want to use a pivot table, require the second table but correct sum.

[kaushiknsolanki]

Hi,

Try this

Sum(Aggr(sum((ConfirmedShippedQty)) * Sum([Item Table.AREALABEL]),LinkITEMCODE,MonthSip....))

Regards,

Kaushik Solanki

[bnelson111 · Accepted solution]

Got it.

sum(aggr(sum((ConfirmedShippedQty)) * Sum([Item Table.AREALABEL]), [LinkITEMCODE]))

Thank you.

[bnelson111]

Thank you