I’d like to get the SUM of ‘Mileage’ and the SUM of ‘Number of tolls’.
I know that I could use a numeric aggregator, but this would only work for ONE of those things, as you can’t use two.
Would appreciate your suggestions!
Welcome to the Make community!
Use an Array Aggregator first.
Then, use a Set multiple variables with the map and sum built-in functions.
For further assistance, please provide the following:
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 and select “Download output bundles”.
A.
Save the bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.
Uploading it here will look like this:
bundle.txt (12.3 KB)
B.
If you are unable to upload files on this forum, alternatively you can paste the formatted output bundle in this manner:
-
Either add three backticks
```before and after the code, like this:```
input/output bundle content goes here
``` -
Or use the format code button in the editor:
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!
samliew – request private consultation
Join the unofficial Make Discord server to chat with us!
2 Likes
Thanks for your reply!
Here is the output of the Array Aggregator:
bundle.txt (398 Bytes)
DataError
Failed to map '0.value': Function 'sum' finished with error! Function 'map' finished with error! '49' is not a valid array.
Your reference for map needs to reference the array first and then the key as the second reference.
Map(array;mileage (d))
The key has to be the raw name of the key name and needs to be typed out.
3 Likes
I’m travelling at the moment, so here are some resources on how to use the map function:
Links
Here are some useful links and guides to help you get started and learn more on how to use the Make platform, apps, and app modules —
General
- Help Center | Tutorials
- Make Academy – learn Make and get your certificate ← CHECK THIS OUT
Help Center Basics
- Mapping – What is mapping? What can I map? ← CHECK THIS OUT
- Mapping with arrays – How to map items in an array ← CHECK THIS OUT
- Tokens for
parseDate| Tokens forformatDate - HTTP modules – Make a request, Get (download) a file
- Webhooks – Error Handling, Responding to webhooks
Articles & Videos
samliew – request private consultation
Join the unofficial Make Discord server to chat with us!
3 Likes
Thank you @alex.newpath - I did indeed have that set wrong!
This link helped a lot, too - thanks @samliew
- Mapping with arrays – How to map items in an array ← CHECK THIS OUT
Screenshot of it working, just for documenting (note my raw names, oddly, were ‘3’ and ‘4’):
3 Likes
Those are probably Column numbers from your spreadsheet. The user interface in make hides that with the actual column name and letter.