I am on SAP Business One for Hana 9.2 PL4. We would like to calculate the GP as percentage on Sales Quotation rows. We have a FMS at row level linked to a UDF. The FMS query is ($[$38.123.2]/$[$38.21.2]), however it gives the following error
1). [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Syntax error or access violation;257 sql syntax error: incorrect syntax near "KES 241,950.00": line 1 col 2 '' (SWEI) (at pos 2)
How to we get the query to exclude the currency symbol in the calculation?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.