FMS 3 Decimal Places

[Former Member]

Dear Experts ,

I tried Working for a Formatted search in Purchase Order , the result is the product of U_Field and PriceBefDis

I want 3 digits since it s very essential for Customer, but formatted Search is getting rounded to 2 digits.

I have tried all queries posted in Forums,The Same result ,it is rounded of 2 two digits

can we do FMS to display 3 decimal places

Mohamed

[Former Member]

Thanks

[former_member206488]

dear,

paste your query here and what is the type of UDF's you created.

[Former Member]

Hi Neetu,

This is the Query I Tried

declare @a as money

declare @b as money

declare @c as money

set @a=$[$13.u_pw.11]

set @b=$[$13.U_Pu.11]

set @c=(@a*@b)/100

select @c

Mohamed

[former_member204969]

Try with this select:

Select str(@c,10,3)

(It converts the result to string using the str(expression,length,decimal) function.)