OpenGround Wiki Example Calculated Values Expressions

Example Calculated Values Expressions

The following table gives some examples of equations that can be used in a calculated heading in OpenGround Cloud Data Collector

next('DepthBase')	The next value used for this when the records are ordered by depth fields.
next('DepthBase',’DepthTop’)	The next value used for this when the records are ordered by DepthTop.
Sum(‘Blows’)	Total value of all current records for this parent. Header name is case sensitive and must be enclosed in single quotes. Records are ordered by the Header by default.
PenetrationSeating1 + PenetrationSeating2 + PenetrationMain1 + PenetrationMain2 + PenetrationMain3 + PenetrationMain4	Add all the penetration values together to show a total penetration value.

Recommended