row query differ formula

[former_member294713]

Hi all,

In my Production Order I have 5 process in the WOR1 and  I need in differ formula on each row process as below:

Row 1 Process = A and formula UDF_A - UDF_B*UDF_C

Row 2 Process = B and formula UDF_A - UDF_B*UDF_D

so, when the row = A, the formula result as A and

              the row = B, the formula result as B

May I know how the query work? thank!

[Former Member]

Hi,

How do you define Process A or B?

Thanks,

Gordon

[former_member294713]

Hi,

I define it at Item Description text as

row number 1 if the item description text as "M1" the formula as (ex. field A - field B* field C)

row number 2 if the item description text as "M2" the formula as (ex. field A - field B/ field C)

row number 3 if the item description text as "M3" no formula.

Thanks.

[Former Member]

You may use case clause to try:

UDF_A - UDF_B * (Case Dscription WHEN 'M1' THEN UDF_C WHEN 'M2' THEN UDF_D END)

[former_member294713]

Hi Gordon Du,

my query formula as below:

Select round($[WOR1.U_PassWt.Number]/ $[WOR1.U_UwC10pcs.Number]*10000,0)

This query is I cal my qty base on my weight, I have many process on my production order row and every row base on the Item Description field to done the differ formula.

Item Description 'M1' formula as: Select round($[WOR1.U_PassWt.Number]/ $[WOR1.U_UwC10pcs.Number]*10000,0)

Item Description 'M2' formula as: Select round($[WOR1.U_PassWt.Number]/ $[WOR1.U_UwC10pcs.Number]*UDF_111,0)

and 'M3' no formula continue

Item Description 'M4' Select round($[WOR1.U_PassWt.Number]/ $[WOR1.U_UwC10pcs.Number]*UDF_222,0)

Am I explain clearly and can this be done? thanks!

[former_member184146]

Use the below FMS

SELECT $[WOR1.UDF_A ]- $[WOR1.UDF_B]*$[WOR1.UDF_C]

--Manish

[former_member294713]

hi manish,

I need the differ formula by my process on row...thanks!