Has there been any improvements because I am having the same problem

@akul.whitehatjruwh When you write “I am having the same problem” it’s really hard to know what exactly is happening in your project. Can you provide some details? A screenshot of the blocks you’re using would be helpful.

with all numbers

Well I got the solution to the problem…Sorry if I wasted your time

You can convert the text input to a numeric value by adding 0 to it or multiplying it by 1 then apply any mathematical operation on it.

can you tell that it will help other users

I suspected – and @muneer confirmed – that you have to first convert the text value to a numeric value by adding 0 or multiplying by 1 and then you can use more advanced math functions like square/exponential power.

Hi tatiang, muneer

I am having the NaN issues so tried the conversation by adding zero which has now resulted in the updated value in the google sheet to be stored as value. As a test, I have a label that displays the value that I am trying to update and that still shows as NaN. The cells have an original value that was created via thunkable and it is stored in the sheet as a number. the original value displays correctly as a number so the error is just from the update any ideas?

a NaN is a result of the attempt of converting none integers to numbers. If the value is formatted to have a leading character or symbol then you need to get rid of it first. The unusual number separators are also considered as none integers and would cause a NaN error if found first.

I created a small block to test the value given.

This is the result

The value uses the math block to set the starting value to 500 and is declared as a number using the math block this is updated to G-sheets where is displays as a number of 500 I am able to use it as a number in sheets it’s then stored as a variable in the app and later used in addition I have done as suggested and added 0 to the values to be updated but no joy. The value is not used as text at any point in the app. Any other ideas?

Can you share a screenshot of the codes that brings this error?

What is the initial value of `stored variable leaderboard_score_total`

?

This is initialized as a stored variable and sets initially to **Null** and would not accept any kind of mathematical operation unless it is first reset to ZERO or any other value than **Null**.

You need a code block like this either on the start/open of the screen or before you do your maths.

Brilliant! it’s now showing values. I had set it to 500 on sign up but it seems it needs to go to zero first. but looks like this is working now. Thanks so much.

## The easiest way is to set the keyboard type to numeric

Thank you for your suggestion @suhanibansal , however, in this case the value is retrieved from a Google sheet row and the keyboard settings will have no effect.