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.