How to set parameters using RoundUp in a formula

I need to set a business process parameter C (integer) as the ceiling of A/B (both integer parameters).

I tried using the following formula:

RoundUp([#A#]/[#B#]) 

but when trying to save I receive this error:

Formula value error: No applicable method 'Ceiling' exists in type 'Math' (at index 5).

Is there anything I need to include in my business process to be able to use the RoundUp function? I already tried RoundOff and it returns the same error.

Like 1

Like

1 comments

Hello, 

 

In versions 7.17.3 and 7.17.4, to resolve the error, it is necessary to disable the feature Feature-UseTypeCastExpressionValidationInProcess by adding the following line to the application's \Terrasoft.WebApp\web.config file:

xml

<add key="Feature-UseTypeCastExpressionValidationInProcess" value="false" />

As an alternative solution, the issue can also be resolved by explicitly specifying data type casting in the formula.

Conversions that may lead to precision loss—for example, the error message “An error occurred in the formula: Cannot convert type 'Double' to 'Int32'”—must be handled explicitly through proper type casting.

 

Thank you !

Show all comments