Summation of data to a given depth

This could be done either via gINT Rules (programming - check 'gint_rules_code.pdf' manual that comes with gINT) or it would require a SQL statement (check gINT Help for 'SQL' or 'Queries' items). In very generic terms the statement might look something like this:

Select Sum([Table].[Depth])
From [Table]
Where [SomeField] = 'your condition'

You may also look into User System Data to possibly save the result and reuse it elsewhere in gINT. 

Thanks for the help, but I don't know what condition to use.

When I use

Where [Field].[Depth] = [Depth],

I gives me the sum of all the data in the field yet I need the sum of the data above different depths.

In your initial question 'I want to calculate the sum of data in a field up to a given depth...', your condition is likely defined by this part - how is the depth given? Are you looking for a depth to certain stratigraphy (for example, depth to bedrock), depth to water levels, depth to an environmental reading? This is likely your condition. Here is an example from gINT Help under Queries:

The total thickness of some layer encountered in the boreholes:

Select Sum([Bottom] - [Depth]) As [Total Layer Thickness]
From [LITHOLOGY]
Where [Graphic] = 'CL'

Calculating a total depth, if observing from the ground level might be even simpler. You may also take a look into Max function. 

I actually want to present data of some field strength tests. During the test, we counted the number of blows per 0.1m depth. I now want get the cumulative blows up to all depths, say 0.1, 0.2, 0.3, 0.4, ..... 5.0, .... 10.0m.

I need to present this cumulative sum of all blows by plotting it on a vs depth graph.

Joshua,

If you are looking to receive the exact expression, then you would need to provide your gINT project (.gpj file). When expressions are written, one needs to know the table names, field names and how the fields are structured. For example, there are various ways of how blows are recorded in gINT project - all blows in one field, each blow in a separate field, or something else. 

Also, you posted a question in a wrong forum. This is the Announcement Forum, which seems to be used mostly for announcements by Bentley. If you want to continue this discussion, please aks forum administrators to move this discussion in the appropriate forum.