'NaN' in field 'Category' cannot be converted to decimal

AppSheet AppSheet Q&A
1

Hi Appsheet Community

I have a problem updating my App as it is unable to save a new row because of a repeating error:

Unable to update row in table ‘Product A’. → Value ‘NaN’ in field ‘Subcategory’ cannot be converted to type ‘Decimal’.

I have tried different approaches to correct the issue, without success …

Can you please guide me to solve the problem as it stops the entire application?

Awaiting your support,

2

What is the exact value you are trying to save with the form view?

3

Hi Aleksi,

When I save an updated form view, naturally, I get the “SYNC” circle in the upper right corner. It disappears in a couple of seconds and then reappers again.. The 2nd circle stays unchanged, I mean it never syncs. After that I need to “Reset Changes”

4

When I checked the Google Sheet for changes, I was surprised to find out that the first “SYNC” operation works, - the changes are in the spreadsheet. But the second one, stays until I reset it manually.

“NaN” - appears when we get the division operation when 0/0, we divide Zero by Zero. It may be one of the reasons, I am not sure

5

Does it work properly when you devide it with something else than zero?

6

The point is I can’t find the error. It takes that “NaN” from nowhere, I can’t find the reason behind it more than two days already

7

The column it refers to is absolutely clean, I have even changed it “Text”

8

#1 - What is the exact value you are trying to save with the form view?

#2 - Does it work properly when you devide it with something else than zero? Yes or No?

#3 - What is your exact formula with the initial value or app formula field that makes this calculation?