I have a form called Recruitment, and in that form I have the following fields:

 

Target (number field)

Current Recruitment Total (number field)

Local % (formula field)

Range (dropdown field)

 

Local % calculates Current Recruitment Total/Target * 100

 

What I want to do is create a report that will have Range on the x-axis  and count of Local % on the y-axis.  The reason for this is that when I currently create a report, it automatically generates the x-axis for me, and I do not want that.  I want my x- axis to have the following ranges:

 

no recruitment

1 - 40

41 - 80

81 - 90

91 - 100

+ 100

 

So I created Range so that I could drag this in the Report generator and hopefully get the intended results.  That part should work fine, however, I would like to add a script for the On Success for both Form On Add and Form On Add so that I do not have to manually do this each time. 

 

I did the first bit of the code ok:

 

if (input.Local = 0)

Range = "no recruitment"

 

That bit works, however, I cannot seem to get the code right for the following bit:

 

if (input.Local >=1 and <=40)

Range = "1 - 40%"

 

I know the main issue has to do with the use of "AND" but as a novice, I really do not know how else I can script this.......

 

I have tried the script using "concat" but refused to work and I have up.