sum in a repeater that is connected to multi datasets

Ask the community
,
1

Hello, I hope you are all doing well. I’m stuck in logic if anyone can help me it would be more helpful and I’m new to Velo as well. I want to show a sum of transactions in a repeater but here is my scenario:
I’ve 2 datasets one is “vendor dataset” which is our primary dataset and it has vendorCode, vendorName, address, etc then I’ve another dataset “transactions dataset” which has the totalAmount, reference, and status fields, and I set a filter on it that reference field of “transactions dataset” is current value of vendor code field of “vendor dataset”. So now I connect a repeater to “vendor dataset” and that repeater has 4 elements
1- Name element which is connected to “vendor dataset” vendorName field,
2- Vendor code element which is connected to the “vendor dataset” vendorCode field,
3- A table which is connected to the “transactions dataset” and it’s showing the amount of the successful transaction according to the vendor code in every repeater container i.e if the first vendor has 3 successful transactions it’s showing 3 rows in his table of repeater container and if second have 2 it’s showing 2 rows in the table and so on,
4- I have a “sum amount” element in repeater and that’s where the problem is caused I wanna show the sum of transactions for every single vendor in that field, like if someone has 3 successful transactions then the sum of those 3 would add in “sum amount element”. But when I push those sum values in the repeater it only displays the first user’s sum on all the repeater elements. So the point is how can I pass the values that I’m getting through the promise of sum query, how can It assigned correctly to every vendor according to the vendor code? I hope so I could define my problem, thanks.

2

Already solved?

By the way, it will surely be your very confusing description, why you never got an answer.

Instead you should do the following…

  1. Add also some pics of your SETUP
  2. Add pics of the related DATABASES which are connected to related DATASETS.
  3. Show which DB is connected to which DATASET on a pic.
  4. Let your helper see, what you have in front of your eyes.

Sometimes pics can show you more than a 10000 letters valued message or description.

If you have sensitive DATA inside your DB you don’t want to show. create an example with an example-setup.

Also show your current code.
You don’t have any code – > because you worked just by the usage of the property-panel? → no way to success!

You will need some code.

Or even better, you start to code it completely. :grin: