Formula to create special field

spudmcc
spudmcc used Ask the Experts™
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
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
What is {avg draw}?

Author

Commented:
that is a field with a number in it.  
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"
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

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"

2. Drag and drop this formula on your group footer/header

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


field means your summary field..

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"

Author

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

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial