If Condition

[dseelam]

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

[aarkay29 · Accepted solution]

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))

)

[hemanthaanichet]

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))

)

[Anonymous]

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.