I’m doing a database search where the result is a list of numbers, I need to multiply each number per a coefficient of their own, then summing the whole result.
Everything is done from an API Workflow.
Example of application : The detail of an ecommerce order is pushed to Bubble through an API Workflow, each product only appears once in the list, but is combined with a quantity.
I need to mutlitiply each product price (prices are stored in my database) per their quantity and then sum the result to obtain the order total.
It seems easy on the paper, but I’m really struggling as I can’t use the “*” operator on a list of number before doing a :sum
Thanks you very much for your help !