Hello.

I have been trying to place a formula that does a mathematical calculation in the “Auto Compute” section.

The column values that are related in the calculation are some decimals and some time and duration values.

I have seen that by adding the expression “Number([column value)]” or "Decimal ([value]) you can convert certain types of columns to other values to perform calculations.

((([NIVEL_11] - [NIVEL]) * [TK]) / DECIMAL([TOTAL HS])) * 24

in other way is

DECIMAL - DECIMAL * DECIMAL / TIME * 24

The problem I have experienced is that when I try to use "Decimal([TimeValue]) with a time or duration value, it does not work correctly. It blocks the mathematical calculation I am trying to do and does not reflect any value in the column in which I am inserting the Auto Compute Value.

I have been reading your support and guides… Any idea why this works like this?

I tried both “Initial Value” and “App Formula” and I got the same results: the calculation does not work.