cancel
Showing results for 
Search instead for 
Did you mean: 

FMS

Former Member
0 Kudos

Hi ,

I have made 3 udf's named udf1,udf2 & udf3. I want FMS in such manner that udf3 = udf1/udf2.

Regards-

Mona

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi........

Try this and assign it to the UDF3.

Select ((Select $[$TablName.U_UDF1.Number)/(Select $[$TablName.U_UDF2.Number))

Regards,

Former Member
0 Kudos

Hi,

I tried your query but it is not working,but it is not working.I want this fms in the user define table.

Regards-

Mona.

former_member197621
Active Contributor
0 Kudos

Hi Mona

If user define table means try this

select ((select $[dbo.udt1.udf1])  /  (select $[dbo.udt1.udf2]))

Former Member
0 Kudos

Hi Mona.........

the query is right and properl tested. Ok tell me whts your UDT name?

Regards,

Former Member
0 Kudos

HI,

I HAVE ALSO TESTED BUT IT IS SHOWING ME ERROR ZERO VALUE HAS ENCOUNTERED.MY UDT NAME IS @Excise.

Regards-

Mona

Former Member
0 Kudos

Hi..........

The error you are getting it doesnt matter you just run this FMS and apply it to UDF 3.

((Select $[$@Excise.U_UDF1.Number)/(Select $[$@Excise.U_UDF2.Number))

It will give result on transaction level.

Regards,

Former Member
0 Kudos

Hi,

I want result in the UDT itself.I did the same thing i attached the query considering it as run time error.But the fms i tried is not working ?Have you tried both the feilds are quantity ?

Regards-

Mona.

Former Member
0 Kudos

Whts the datatype of the field is it quantity?

Former Member
0 Kudos

yes feild type is qty for both.i even tried by taking alphanumeric but still the query is not working.

Former Member
0 Kudos

Wait Let me check once...........

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Mona,

What form is your current form? Only if you designed a user form linked to your UDT, you may be able to assign this FMS.

Thanks,

Gordon

Former Member
0 Kudos

Hi Gordon,

I want to assign FMS in the UDT itself all the 3 udf's are in UDT itself.The reason why i am doing is in the pld i have assigned two repetitive areas. In the 2nd repetitive area i have captured the details from UDT.

Now, in the repetitive area 2 i have assigned 1 field which is C i.e equivalent to A/B. In the repeatitive 1 there is one field say D,what i want to do is capture 1 value say E = C*D. But i am unable to work it out in pld it is showing error.So thought of applying FMS through which my issue will be solved.

Mona.

Former Member
0 Kudos

If your only need calculate within PLD, no need for the 3rd UDF. Suppose Field_1 is UDF1, Field_2 is UDF2, just add another formula field to calculate Field_1 / Field_2.

Former Member
0 Kudos

Hi Gordon,

I would have not used fms option if the problem would have solved through pld.

mona

Former Member
0 Kudos

Then you have not answered my question: are these UDF in the current form?

Former Member
0 Kudos

Yes,

This udf are in the current form.

mona

Former Member
0 Kudos

Try this then:

SELECT $[dbo.@Excise.U_UDF1.Number\])/$[dbo.@Excise.U_UDF2.Number\]

Former Member
0 Kudos

Hi Gordon,

I need this fms in the udt itself not at the particular transaction which is linked to this udt.After trying this fms it is showing me error.The error is zero value has encountered.

Regards-

Mona

Former Member
0 Kudos

Hi Mona..........

Try this. It will help you...........

Select ((Select $[@Excise.U_UDF1.Number])/(Select $[@Excise.U_UDF2.Number]))

Regards,

Edited by: RAHUL MOUNDEKAR on Sep 19, 2009 1:08 PM

Edited by: RAHUL MOUNDEKAR on Sep 19, 2009 1:09 PM

Former Member
0 Kudos

When you said: udf3 = udf1/udf2, I can only imagine UDF3 is the field for FMS. If they are in the current form, it should work.

Former Member
0 Kudos

Hi Gordon,

I tried but it is showing me error that zero value has encountered.

Regards-

mona.

Former Member
0 Kudos

That means some of $[dbo.@Excise.U_UDF2.Number\] may have value of 0. What do you want to assign to UDF3 if field UDF2 value is 0?

former_member197621
Active Contributor
0 Kudos

hi Mona

Where you want ,i give you example for purchase order

select ($[opor.udf1] / $[opor.udf2]) from opor

assign this query in udf3 field