Convert Scientific Notation to Numeric

[directrix]

Hi, I am new here.

 

I would like to save the table, but it gives me an error: "Unable to save due to incompatible values in one or more formula fields." even if the formula validates OK.

 

I have this formula:

 

And I am trying to replace char to float to convert scientific notation to numeric.

 

[MayMusic]

What error are you getting? Are you creating a table or adding data to a table?

[directrix]

Just edited the original post.

[directrix]

I am trying to modify the formula on the table.

[ElkeD]

Hello, I'm getting the same error when I want to ad a formula to a field.

Unable to save table due to incompatible values in one or more formula fields.

 

The formula is validate OK

 

What can I do?

[BaySunshine]

Is one of those fields a formula field by itself?

To troubleshoot the error, I suggest you to try one case...when at a time. Make a duplicate of your table or add a test record to your existing table and test it out. This way you can narrow down to see which particular field/condition is causing this error.

I hope that helps.

[Franchiser]

On 3/22/2018 at 2:16 AM, ElkeD said:

Hello, I'm getting the same error when I want to ad a formula to a field.

Unable to save table due to incompatible values in one or more formula fields.

 

The formula is validate OK

 

What can I do?

Hi @ElkeD,

I would suggest to CONVERT() all fields data type like VARCHAR, the error looks like a data type mismatched.

 

-Franchiser-

[BaySunshine]

Hello @directrix,

The formula worked for me. What is the datatype of your fields? I have D_Date as Date/Time, D_Serial as Number, D_Text as Text. The error can be caused by the data that you entered as well. Provide us sample data that you entered and I will try to reproduce the issue.

Regards,