I want to calculate sensitivity ratio = peak result / residual result and round up this number to the nearest integer.
I need a 'Roundup()' or 'Round()' expression
Hi Kiyan, I believe the Ceiling() function will do what you are looking for.
Thanks Jesse, I will give that a go
Hi Jesse,This seems to work for OpenGround Professional but not for Cloud Data EntryThe Ceiling() function refuses to save
Hi Kiyan,
When you say "Cloud Data Entry", are you referring to Data Collector (field logging on tablet) or Data Entry (desktop data entry extension)?
I tested quickly and Ceiling() worked successfully in both (a Calculated Value expression in Data Collector & a Default Value expression in Data Entry). Although Professional seems like probably the best place for a sensitivity calc.
Happy to look into it further, but please post your exact expression and how/where you are using the expression.
Thank you,
Jesse
Hi Jesse, thank you for your help
Apologies: I am using Data Collector
I am setting up a Mobile Data Entry profile to perform Hand Auger Logging
A step within this profile is In Situ Shear Vane Tests
I am adding the following headers
The Ceiling() function either does not work with Data Collector or it is a bug
You would need the expression for SSR to be in Calculated Value instead of Default Value.
Also, please check the field references in your expression. I believe it should be [ResidualresultValue] instead of [Resultresidualvalue].