SAP CPQ - Builder Syntax - Formula Builder Error - Converting data Varchar to Float

[samuelconceicao]

Hi Experts,

I'm having a problem to get a simple value based in a custom tablem.
When I declare that the total amount of the quot is Num and select a operator < or > in a CTX of quote (total amout)
Its a Shipping table... Different costs based in the total extended amount... but when I select the total amount.. and build and test formula i got this error..

Does anyone knows why it happening and how to solve it??
The field in the custom table is numeric..


Thanks

[Yogananda]

HI,

Any you share the screenshot of your custom table with field names and expected output with describing ?