Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Currently i'm having INVALID DIMENSION though my expression have no error. I need to divide the value from 1 field to the Qty Shipped.
=(ITEM_UOM_CONVERSION_FACTOR)
/Num(
(Sum({$(eSales_Qty)}UNITS_PRIMARY_QUANTITY_SHIPPED)
+Sum({$(eFOC_Qty)}UNITS_PRIMARY_QUANTITY_SHIPPED)
+Sum({$(eReturn_Qty)}UNITS_PRIMARY_QUANTITY_SHIPPED)
+Sum({$(eBonus_Qty)}UNITS_PRIMARY_QUANTITY_SHIPPED))
,'#,##0')
Aggregations aren't possible within a dimension unless they wrapped with an aggr() which makes it to a calculated dimension. Means something like:
aggr(YourExppression, Dim1, Dim2)
whereby Dim1 and Dim2 are placeholder for the dimensionality in which context the calculation should happens - often it are the other dimensions from the object but sometimes it may also a granularity deeper.