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