Question

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