Hi Marco,

I am sorry, but I am not understanding exactly what you wish to achieve.

Our calculations are going to take the value of a number in any cell exactly as it comes from your data source.

It is not possible to 'transform'/change that number before it gets taken into account for a calculation or Formula column.

For example, if you set a Conditional Rule and change the content of a cell value - this can not work for calculations of formula(s) because they will take the actual/underlying value before it gets 'transformed'.

So if that is what you need, I am truly sorry to disappoint you, but we don't have a way to dynamically change any value which is negative coming from the data source and set it to be zero for calculations or Formula.

But let me know if we misunderstood what is the goal.

If so, please elaborate in more details, show us some screenshots or a Video, how is the source value looking, you can show a few values, then how you are using them in Total calculation versus how they should be for your desired use-case, etc.

Thank you.