Conditional Formula

Help Center Get Answers
1

I'm trying to take a numeric field value and "cap it". Basically if the value of the 1st field is more than 250, use 250 instead of the orginal number.

What I currently have is {Fee} > 250 ? :250

but all this is returning is a 1 instead of 250 for a fee of 4363.84. What am I doing wrong?

2

Never mind - figured it out with

{Fee} > 250 ? 250 : {Fee}