Power Platform Community Forum Thread Details

I need help on How to get the sum of data in a column and display its total value in other entity. In model-driven app

Hello! I was learning model-driven app for a while now and I was confused how to figure this one.

I have three tables in my solution, one is for the contact, two is for inventory and three is for equipment assignment. So the purpose of the app is to provide simple inventory of the equipment.

* in my inventory table the columns are equipment, use quantity and total stocks

* in my equipment assignment, the columns are user, which is a look-up field to contact table and a column for Puncher, scissor, pen and so on, they were equipment which is in a number data type.

Now, what I want is to total the data for example in the puncher column. As shown below, in the puncher we have 2 and 1. So i want my use quantity for puncher to have the value of 3. There's no relationship between two table at all. I just want to display its total value

I don't know if it is possible, but I REALLY NEED HELP😥

I have errors uploading picture of the app, So i'll just provide table

Inventory Table

Equipment

Use-Quantity

total stocks