Math formula doesn't want to give the correct output

1

Hi,

I have the following formula but it keeps returning 0 in the preview app.

Please can you assist?

(SUM([pageVars.income1,pageVars.income2 ])-SUM([pageVars.expense1,pageVars.expense2,pageVars.expense3,pageVars.expense4,pageVars.expense5,pageVars.expense6,pageVars.expense7,pageVars.expense8,pageVars.expense9,pageVars.expense10]))

Screen Shot 2020-09-19 at 21.43.32
Screen Shot 2020-09-19 at 21.43.322256×1034 223 KB

2

Hi there!

It sounds like one or more of the variables might have an incorrect value or type. I suggest you try debugging this by printing all the variables out with a simple joining formula like: JOIN([ pageVars.expense1, pageVars.expense2, ...]) to see what the individual values are when you’re trying to sum them. Perhaps that way you can figure out which is the problematic value.

3

Thank you Akseli,

I tried this but it gives me all numeric values.

4

I tried this, but wasn’t able to repro the issue. If you’re sure that all values arrive as numbers here, could you share me your app ID so I could take a look at the problem and see if I could find the root issue (or a bug)?

5

Hi,

The build is 105930

Thank you

6

Screen Shot 2020-09-22 at 17.36.58
Screen Shot 2020-09-22 at 17.36.582232×890 89.5 KB

7

Could you tell me where to find the Formula? And how to test it on the app?

8

Hey

It’s on the budget page on the button at the bottom. It’s an alert I added to the button.

You can just preview the app and on the budget page you can enter all the amounts in there.

9

This is due to numbers actually becoming text type after user input. If you add NUMBER() around each value this should work correctly.