Screen Value

[Former Member]

I have a query

SELECT ($[$38.U_QTY.Number] * $[$38.U_RATE.Number]) / $[$38.11.NUMBER]

This query gives me some result e.g. 230, but the real output is 230.23, so i want to pick the decimal value in my query,how can it be possible.

Regards

[former_member204969 · Accepted solution]

Try this one:

SELECT (cast($[$38.U_QTY.Number] as dec(19,6)) * $[$38.U_RATE.Number]) / $[$38.11.Number]

(Then the system will not evaluate the expression as an integer one.)

[former_member187989]

Whether you are applying FMS result in UDF ?

If it is UDF field what is data type of it ?

Jeyakanthan

[Former Member]

use

SELECT ($[$38.U_QTY.0] * $[$38.U_RATE.0]) / $[$38.11.0]

This would return the complete value in the item(cell).

[Former Member]

this will give the internal error.

Regards

[former_member583013]

Sandeep,

Where are you linking this query? Could be give me an example of the 3 values from where you are getting the 230.23

[Former Member]

Hi,

Actually i have 2 user defined field in which i capture length of a item and another is for rate in sales order form.

Now I am calling a query in which is like this (length * rate) /unit price .the query is running fine with even numbers,but when it's get a odd number it does'nt give the right output, because it did'nt give the results in float .

e.g. length=1235,rate=8 , unit price 25

(1235*8)/25=395.2

but it's give 395

Regards