Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
how to write this as proper expression
show me
sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST) / sum(SHIPPED_QUANTITY) +
sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)/ sum(SHIPPED_QUANTITY)
If above expression gives zero
show me
[Old LO] in same column
Thanks
D
If(
(sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST) / sum(SHIPPED_QUANTITY) +
sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)/ sum(SHIPPED_QUANTITY))=0,[Old LO],
(sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST) / sum(SHIPPED_QUANTITY) +
sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)/ sum(SHIPPED_QUANTITY))
)
If(
(sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST) / sum(SHIPPED_QUANTITY) +
sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)/ sum(SHIPPED_QUANTITY))=0,[Old LO],
(sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST) / sum(SHIPPED_QUANTITY) +
sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)/ sum(SHIPPED_QUANTITY))
)
try this:
If(
((sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST) + sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)) /
sum(SHIPPED_QUANTITY))=0, [Old LO],
((sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST) + sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)) /
sum(SHIPPED_QUANTITY))
)
Hi Dinesh,
Use below If condition: (Assuming denominator sum(SHIPPED_QUANTITY) <> 0 in your case)
If(
sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST) =0 and
sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)=0
,[Old LO]
, (sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST) / sum(SHIPPED_QUANTITY)
+
sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)/ sum(SHIPPED_QUANTITY))
)
Thanks.