format for output with money

Question

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

Kottapally_Ramesh · Answer

Hi @Hi2023 ,

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

caltang · Answer

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

Qiu · Answer

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