Is there a 'Round' expression one can use in calculations?

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

Parents Reply
  • 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.)

Children