Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone help? I have a measure field named Delivered Quantity where
Delivered Quantity = sum(aggr(sum(DISTINCT [Delivery Qty]), [Sales Order],[Sales Order Item No.]))
and field of Order Qty.
Now, i need to have another measure field that will match if Delivered Quantity = Order Qty.
How can I do that?
may be below. Assuming sum([Order Qty]) is your measure.
sum(
aggr(
if(
sum(DISTINCT [Delivery Qty])=sum([Order Quantity]),
<here write what you want to do if condition matched>
)
,
[Sales Order],[Sales Order Item No.])
)
may be below. Assuming sum([Order Qty]) is your measure.
sum(
aggr(
if(
sum(DISTINCT [Delivery Qty])=sum([Order Quantity]),
<here write what you want to do if condition matched>
)
,
[Sales Order],[Sales Order Item No.])
)
Thank you! It worked. I also tried to add as variable.