Sum of value in collection inside an array from a data store

Hello I am trying to use a data store record number in makes math functions to use for billing a client but this is proving to be a lot more difficult then expected.

When trying to sum the values make just places the value in order to create a large number instead of summing them.

I am attempting to sum the values of number of resolutions from each week and then bill the client for the total number for the entire month.

Thank you in advance for the help!

Welcome to the Make community!

If you are unable to sum the variables correctly, it could possibly mean that they are a of a string type instead of a number type. You could use parseNumber function to convert each of those variables into a number before adding them up.

1. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

(Note: Exporting your scenario will not include private information or keys to your connections)

Uploading it here will look like this:

blueprint.json (12.3 KB)

2. And most importantly, Output bundles

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module, save the contents as a text file, and upload it here into this discussion thread:

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!


Uploading: Screenshot 2023-11-09 at 5.40.48 PM.png…
I was able to figure it out and want to share it just incase anyone else runs into this issue. I just needed to pair the array, iterator and numeric aggregator together

Heya @Marc_Eastin I just wanted to quickly let you know that the screenshot you provided is not visible to the community. Could you please re-upload?