format for output with money

[Hi2023]

hi,

I need help with a formula I have that is using a conditional statement amount-as a fixed decimal with a order# -int64  and the output is changing it the .51 to 51.00 ---- how do I correct this? I also then tried to change the amount as a double with order# as a int64 and nothing! 

oh and in the actual formula it is greyed out as V_WString

[Qiu]

@Hi2023 
I could not fully understand the error itself, can you post a snapshot to help?

[caltang]

Hi @Hi2023 

As @Qiu pointed out... I am having a hard time understanding your issue. From what you explained, it seems like you are trying to use a Formula tool to overwrite an existing field that already has an existing field type of V_WString...

Some data or even your exported workflow would be most helpful + an end state (expected output) would be greatly appreciated. 

-Cal

[Kottapally_Ramesh]

Hi @Hi2023 ,

Please share some sample data to understand the issue & it will be easy to workout.