Hi Community ,
I would like to seek your help to comment on the following screenshot as i not sure why the formula is not working in this case.
Could anyone please advise me on the mistake that i have made?
Thanks a lot.
@SH_94
Based on the error message you are trying to apply a math function to a string. Can you check if Days or Invoice Amount (Ori) are strings? Once you update them to be numeric using a select tool it should work.
Hi @SH_94 ,
it seems, the field [Invoice Amount (Ori)] is a string field. Replace [Invoice Amount (Ori)] by ToNumber([Invoice Amount (Ori)]) , thus you convert the string to a number and it should work.
Let me know if it works for you.
Best,
Roland
You could remove the comma in a first step using the formula Replace([F4], ',', '') for field [F4] without any changes on data type and use ToNumber([F4]) in a second step. What's the result?
I think, the brackets indicate negative numbers. You could add two additional Replace functions (two additional formulas, both with [F4] selected
Replace([F4], '(', '-') to replace the opening bracket by a minus signReplace([F4], ')', '') to remove the closing bracket
This should convert (1764.23) by -1764.23, and this will be converted to a number correctly.
Give it a try.
Hi @ Lukecornetta and Aurora RolandSchubert,
Thanks a lot for your great information
Hi RolandSchubert,
It appear the error as below after i put the formula : ToNumber. Can you please advise on this?
