How to sum from two different datasets

Hey, I am looking for an example where a sum is made between two different datasets. I am not accomplished writing scripts :(. Hopefully someone can help me with this? I would appreciate it very much :slight_smile:

Should V.A. be a text value? If you want to sum that with another number, should V.A. not be a number?

Hi Andrew,

Thanks for your comment, I’m going to adjust this. Do you know how I make this formula?

it will just be something like:
wixData.query(database-name).find().then((results) => ‘database-results’ = results.items[0]
Then use your database-results to get the relevant information.

Hey I’m looking to do this too … I can sum within the same dataset no problem, but adding two values from two different datasets seems tricky. I’m guessing the code needs to go in the backend but can’t figure out how to do it … if anyone can give an example code I’d be very grateful

Hi Andrew,

I don’t quite understand where to put this script. Is it possible that you give a little more explanation about this? Working with scripts is still very new to me, although I am starting to understand it more and more :).

It would be nice if I understand this, then I will be one step further and I can make beautiful links again :slight_smile: :slight_smile: