[JMathers]

I have a dependent field (text field with Validate ANY) that has a SQL Connection with SQL to query an invoicing table on a MS SQLServer. The SQL query obtains the selling price which is a Decimal(11,4) field. The dependent field/SQL works and retrieves the data, however it only ever shows a whole number - the decimal precision is not obtained (e.g. SQL Table field is 51.5900, but Processmaker retrieves 51). Is this a bug (I am running version 2.0.45) or is there something I am missing?

[ethanpresberg]

Try using instead of a text field, a currency field with validate real number.

[JMathers]

If I set the field type to Currency it will not allow me to select is as a dependent field (it does not show in the list of dependent field choices in my other field). I have tried using the real number validation in the existing text field but this did not work.

[ethanpresberg]

Ahh sorry didnt see that you said dependant field.. Did you try using a mask?

[JMathers]

Tried the mask (###,###.##) but it still only retrieves an integer value (If I clicked in the field and tab out it would apply the mask, but the decimals were always zero (51.00).

[JMathers]

I was able to find a solution/work around by using CAST to convert the decimal to a VARCHAR:

select cast(ORD_PRICE as varchar) from ORDERS where ORDER_NO = @@Order_No;

[ethanpresberg]

ahhh interesting solution. i wonder if this is not a bug.

[userg19]

I was able to find a solution/work around by using CAST to convert the decimal to a VARCHAR:

select cast(ORD_PRICE as varchar) from ORDERS where ORDER_NO = @@Order_No;

i think will help you this
select IFNULL(format(sales,2),0)