CODEWITHSUNDEEP
fluttergoogle-cloud-firestoreflutter2.0
Rafael Zablah
Rafael Zablah

Reputation: 35

how to sum values of a field inside a firestore collection related to another collection in flutter 2.0

I'm a little lost here, I'm trying to get the sum of a specific field, my code here:

Future _sumCarta() async {
    await _firebaseServices.usersRef
        .doc(currentUser)
        .collection('Cart')
        .get()
        .then((querySnapshot) {
      querySnapshot.docs.forEach((element) async {
        // here I want to sum
         num value =  element.data()["price"];
      });
    });
  }

I want to get the sum result of all documents, any help or ideas are welcome, thank you

Upvotes: 0

Views: 1248

Answers (1)

Frank van Puffelen
Frank van Puffelen

Reputation: 598668

Wouldn't that be:

num sum = 0.0;
querySnapshot.docs.forEach((element) async {
  num value = element.data()["price"];
  sum = sum + value;
});
print(sum)

Upvotes: 2

Related Questions