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?

Like 0



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

Federico Buffa 😀,

Ternary operator execution helps! 

Show all comments