Jump to content
  • 0
directrix

Convert Scientific Notation to Numeric

Question

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:

Frml3.PNG.75f75f79004047eaf6d63df914d3ec36.PNG

 

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

 

Share this post


Link to post
Share on other sites

7 answers to this question

Recommended Posts

  • 0

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

icon_alert_stop.png?a=11.0
Unable to save table due to incompatible values in one or more formula fields.
 
The formula is validate OK
 
What can I do?

Share this post


Link to post
Share on other sites
  • 0

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.

Share this post


Link to post
Share on other sites
  • 0
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.

icon_alert_stop.png?a=11.0
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-

Share this post


Link to post
Share on other sites
  • 0

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,

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×