Calc error - recognises value as text

I’m building a scenario and am stuck on a particular issue which is driving me crazy! I need to multiply the ‘total-floor-area’ (pulled via a ‘make a request’) by 10.7639 (to convert to sqft), however I can’t seem to make it work after much troubleshooting. I think this is because it recognises the output as text, rather as a number (see screenshot). I did the same calc via the ‘set variable’ tool with ‘bedrooms’ from a different ‘make a request’ as this was showing as ‘number’, and it worked). How can I ensure that total-floor-area is recognised as a number? Or is there an easier way to do this simple calculation? Any help is much appreciated - cheers :slight_smile:

Hello @Amir_Thakrar and welcome to the Make Community!

If total-floor-area is text, you may use the parseNumber function to convert it to a number before multiplication. Please give that a try and let us know how it goes!

Thanks Donald for the response.

I’ve tried that and it didn’t seem to work. I’ll try again though - are you able to advise exactly what to input?

Please give more examples of how you structured the function and what the output was.

Here’s how the parseNumber might look:

2 Likes

Oh amazing, working now! Thanks so much for the support :slight_smile:

2 Likes

@Amir_Thakrar, thanks for confirming it’s working for you now. If you would be so kind as to mark my response as the solution, it would be much appreciated!

1 Like

Sure. I’ve come across another issue if you’re able to assist Donald?

I need to merge 31 and 32 - I’ve tried this using array aggregator, but it’s not letting me connect both 31 and 32. I’ve set all the variables to be the same. After merging the two, I need to conduct another http make a request to pull in some additional data.

Hello @Amir_Thakrar,

Since this topic has already been resolved, kindly make a new post for this new issue to keep the Community clean and organized. Thank you!