This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Amazing, I managed to get the results that i wanted. Thanks a lot for your help.
But i still don't understand on the concept below whereby we keep the name as F4 and in the formula tool add it new column. Could you briefly explain the concept/logic behind why we need to do in this way :
In the Select tool, do not change the data type and field name (so the name is still [F4] and it's a V_WString).
In the Formula tool, add a new column and name it Invoice Amount (Ori)", set the data type to double and use the formula ToNumber([F4], 0, 0, '.').