Calculated metrics question

Hi Team.

I want to know if there is possible to resolve this with the calcualted metrics.

I want to sum a column in the object but if that value is negative, show 0 insted of the negative value.

The oposite case is if the sum is above x number I want to show x insted of the value.

Is that possible to achive?

https://marketplace.creatio.com/app/calculated-metrics-creatio

Like 0

Like

2 comments

Found it. Using formula 70-a> 0 ? 70-a: 0

Federico Buffa ?,

Ternary operator execution helps! 

Show all comments