converting from one data type to another datatype

[Former Member]

Hi Masters,

Actually in one data service the output field is of type "Number". In another data service the input field which is same is of type "Text". I want to assign the value from one data service to another. It is not allowing me to do that. How can I change from Number to Text and from Text to Number.

Please help me.

[Former Member · Accepted solution]

HI,

you have use the formula. There are "text functions" and "numeric functions". Place the course over the function and an help text will be displayed.

To reach the formula, you have doppelclick on the UI that you have choosen.

Hope this helps, if not let me know I will send you an screenshot so that u can understand what I mean.

Regards

Marcus

[Former Member · Accepted solution]

Hi Marcus,

I have tried that,now it is working properly.

Actually i have to convert a number to text.

In Numeric functions there is a formula for doing this.

NSTR(n,mask)

I have specified

NSTR(@volume,0)

Now it is working fine.

Thank you very much.

[Former Member · Accepted solution]

Try NSTR(@volume, ".0") for no decimal places.

Henning