This content has been marked as final.
Show 1 reply

1. Re: Need to cut a calculation field to a certain number
Jim Dehner Apr 11, 2018 8:08 AM (in response to V VV)1 of 1 people found this helpfulNot having the advantage of seeing the calculation it is a little difficult  but if you r calculation is an LOD you can use something like
Min(yourcalc,1) (assuming that your calculation is percentage)
if it is not then you are left with if [your calculation]>1 then 1 else [your calculation] end
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.