FMS

[Former Member]

Hi ,

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

Regards-

Mona

[Former Member · Accepted solution]

Hi........

Try this and assign it to the UDF3.

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

Regards,

[Former Member · Accepted solution]

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 · Accepted solution]

Hi Mona

If user define table means try this

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

[Former Member · Accepted solution]

Hi Mona.........

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

Regards,

[Former Member · Accepted solution]

HI,

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

Regards-

Mona

[Former Member · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

Whts the datatype of the field is it quantity?

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member]

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]

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]

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]

Hi Gordon,

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

mona

[Former Member]

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

[Former Member]

Yes,

This udf are in the current form.

mona

[Former Member]

Try this then:

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

[Former Member]

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]

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]

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]

Hi Gordon,

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

Regards-

mona.

[Former Member]

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]

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