# Formula to create special field

on
Hi All!

I need to create a formula that would add give me this information.  I've tried a number of things but no luck.  In plain old English this is what I need to do. 1--if {avg draw} is between 1 & 19 then low, if {avg draw} is between 20 & 49 then medium, if {avg draw} is > 50 then high.

Any help would be greatly appreciated.

spudmcc
Comment
Watch Question

Do more with

EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
What is {avg draw}?

Commented:
that is a field with a number in it.
Commented:
so it's really {tablename.avg draw}  ?

Then you can do craete a formula field that is..

if {tablename.avg draw}  < 20 then
"low"
Else if {tablename.avg draw}  < 50 then
"medium"
else
"high"

Commented:
Create a formula

1 . if Average( field, groupfield) in [ 1 to 19 ] then "Low"

else if Average( field, groupfield) in [ 20 to 49 ] then "Medium"

else  "High"

Commented:
if you have no group and if you need on report level

Create a formula

1 . if Average( field) in [ 1 to 19 ] then "Low"

else if Average( field) in [ 20 to 49 ] then "Medium"

else  "High"

2. Drag and drop this formula on your report footer

thanks
shiv

Commented:
there is modification on peter comment , formula returns wrong results for medium

that is on medium level you must use

else if{yourfield} in [20 to 50] then "medium"

Commented:
Thank you so much!  This accomplished exactly what I needed it to do.  I didn't want to "group" by this field just create a label which is just what your solution did for me.

I appreciate your time, talent and patience.

Andy (spudmcc)

Do more with