Calculation value not less than 1

[vbpeterson]

Would some be so kind as to help me with a calculated field?

I need the value to be rounded to the nearest whole number, but not less than one.



i.e. ERUCALCULATION: Int([IMPERVIOUSAREA]/2840)

Thank you, Kim

[ketbdnetbp]

You might be able to use...

ERUCALCULATION: IIF(([IMPERVIOUSAREA]/2840)>=1,Round(([IMPERVIOUSAREA]/2840),0),1)

Hope this helps...

Jim

[vbpeterson]

Dear ketbdnetbp, PERFECT!!! Worked GREAT! Thank you so much. I very much appreciate your help.

Thank you, Kim

[vbpeterson]

I spoke too soon. I didn't take into account that I have vacant properties that have ERU value of 0. So I need it to be anything greater than 0 or less than 1 equals 1.

[ketbdnetbp]

Not sure I understand...

ERU value of 0?

Are you saying that, this... [IMPERVIOUSAREA]/2840 = 0 when the property is vacant? If not, please explain detail.

Thanks,

Jim

[vbpeterson]

Yes - [IMPERVIOUSAREA]/2840 = 0 when the property is vacant

I need 0 values to stay 0, but ">0 and <1" values to = 1.

Thank you, Kim

[ketbdnetbp]

So, if I understand it correctly, you might try...

ERUCALCULATION: IIF(([IMPERVIOUSAREA]/2840)=0,0,IIF(([IMPERVIOUSAREA]/2840)>=1,Round(([IMPERVIOUSAREA]/2840),0),1))

Hope this helps.

Jim

[vbpeterson]

HOORAY! Perfect! That does it. Thank you so much for your help.
Kim

[vbpeterson]

Hi Jim, One more question. What if I wanted all values greater than 1 to round to the nearest tenth, instead of the nearest whole number? Thank you, Kim

[ketbdnetbp]

I'm not totally sure on that one but, you might try...

ERUCALCULATION: IIF(([IMPERVIOUSAREA]/2840)=0,0,IIF(([IMPERVIOUSAREA]/2840)>=1,Round(([IMPERVIOUSAREA]/2840),1),1))

and see if that produces the desired results.

All the best,

Jim

[vbpeterson]

That is perfect. Works great. Thank you, thank you, thank you.

Sincerely, Kim