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. |