Sum Values From Multiple Data Types

Hi All,
So I’m having some difficulties and couldn’t find any solutions on the forum so here goes.

Basically I have two data types (Project & Requests) there is a text reference linking the two. Within the Requests type I have 4 numerical fields (value#1 - 4) representing periodic budgets.

Within requests you can have multiple entries with the same project reference (multiple budget requests for the same project)

I want to be able to sum all the numerical values in the requests data type that has a particular project reference.

Hopefully this makes some sense to others, and thanks very much in advanced for the support.

Cheers

This topic was automatically closed after 70 days. New replies are no longer allowed.