Sum in Parent Table using Triggered Action

[OB1Kanobi]

Hello Caspio Forum

Please could someone point me in the right direction here:

I have a child table recording spend per period, type of spend and project. These values need to be summed in a Parent table, for use in other calculations, by:

1. Period
2. Type of Spend and,
3. Project

I have set a Triggered Action that gives is Summing the values per period, but I cannot seem to get it sum per Project. The same values are per Type of Spend are reflecting in all Projects. 

Thank you

[CoopperBackpack]

Hello @OB1Kanobi,

You may join the tables on several required values to add the value to the specific record in the parent table.

For example:

 

I believe that it depends on the particular table design. It would be helpful if you can provide the screenshot of your current Trigger.

[OB1Kanobi]

[OB1Kanobi]

Thank you @CoopperBackpack

I added the screenshots of the trigger for you to have a look at.