Get Total Value From firebase!

[balabharathi.slmkx98]

I have data in firebase! I want to get sum of total from (Total Sqft) get total|427x500:

please help me someone!

[tatiang]

I added the image you linked to so that it appears in the post.

You can learn how to loop through Firebase data and sum values here:

Receive data from firebase to sum

Good afternoon everyone, could someone help me get a specific value of firebase for sum because i am having difficulties. I’ve tried a few things but to no avail. I would like to get all the fields named “consumption” and make the sum [image] { “55AMJ05081990CAA|2” : { “13h17m2” : { “consumo” : 80, “vendor” : “Joelton” }, “13h17m30” : { “consumo” : 25, “vendor” : “Maria” } }, “55CPC08101987MAA|2” : { “13h16m42” : { “consumo” : 503, “vendor” : “Joelton” }, “13h17m17” : { “con…

Source: I Googled loop sum Firebase Thunkable and the link above was the first result.

[muneer]

Welcome to Thunkable.

The only way is to loop through the data in your Firebase database and sum the required values. See the example in the post shared by @tatiang

[balabharathi.slmkx98]

Thanks your replay sir,
I tried same as your blocks but small error is there please help me I will add photos.

Thanks

[mimostel]

When doing math operations, you need to be sure that values are numeric type. To do that, just use math block +0 to convert any text value that looks as a number to a number.
As I see it from your first screen, values are kept as text in Firebase (" are there).
Example: 1=“1”+0
Your result looking as a large number with dots between is just a concatenated text there, for the reason I explained.

[muneer]

Save the values to the list this way

This will force the values stored as text to be converted to numbers and the sum will work.

[balabharathi.slmkx98]

Great Sir it’s Working Properly Very Big Thanks Sir.

[muneer]

Glad it worked for you.