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.
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].
Hi Jesse: I have changed the code and placed it in the Calculated Value blockCeiling([ResultValue]/[ResultresidualValue])
I think the issue now is that when I press Finish the change does not save and I am left with:
[ResultValue]/[ResultresidualValue]
That is odd. I tested above expressions and Ceiling() saved for me without problem.
The only issue I see in your expression is that the field reference for [ResidualresultValue] still seems off.
I don't think that would cause Ceiling() to get stripped so I'm not sure what is happening.
One thing to keep in mind is that if you have the expression in Professional, that value will override the Calculated Value in Data Collector anyway. You just won't be able to see the Calculated Value in Data Collector until you sync.
(And one other thing you may want to be careful of is that in Professional, your Result Value and Residual Result Value fields may be calculated by default based off the Result and Residual Result fields. You may want to deactivate those calculations or change your Data Collector profile accordingly. Although I don't think that's related to above issue.)
It turns out there was an issue with saving expressions that only impacted users on clouds in Azure data centers. I believe you are in ANZ, so that would impact you.
It has now been fixed, so the expression should save properly now.