Add calculated field

Hello,

I would like to add a calculated field of “X/min(Y-Z)”, I am not able to add the minimum of two values. Can you please support ?

regards

Hi,
I tried this and got a mismatched aggregation error. I tweaked it to “sum(X)/min(Y-Z)” and it worked. If you are getting an error for having less then 2 values I would be curious why the min function is needed? If there is only one value in the the Y &/ Z column(s) then the minimum would automatically be equal to whatever Y-Z is for that single row.

Hello,

Thank you for your feedback.
Actualy i am looking for MIN of two values so: X/MIN (Y,Z).
it is delivery metric: Handled contacts / Min ( Offered, Commit).

regards

ahh, gotcha I understand now. Maybe try
X/ifelse(Y < Z, Y, Z)
which returns Y when Y < Z, otherwise returns Z.