Using an IF statement to cap given number in a field

I’m trying to link multiple fields together and cap the number depending on another field’s selection.

For example:

Currently I have this formula working as intended in the a field:

{X field} / WORKDAY_DIFF({Y Date}, {Z DATE})

I want to add a quantifier on top of that will determine the number it puts out.

So, if field A=B, cap the number at 2
If field A=C, cap the number at 1.

Try the following:

MIN(
  IF({Field A} = "B", 2, 1),
  ({X field} / WORKDAY_DIFF({Y Date}, {Z DATE}))
)

That will take your original calculation and insert it if its less than either 1 or 2 (depending on Field A}'s value). If it its higher than that number, your cap number will be shown instead.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.