If ( %score ≥ Value_1 and %score ≤ Value_2 ; 1; 0)
Also consider using the function Sum ( Your_table::your_calculated_field ) instead of Summary
i thought i had it right before i saw you reply with:
If ( %score ≥ "0" and %score ≤ "40" ;1;0)
then you confirmed!
now guess i still need an additional summary field.
then i have to repeat for 10 more ranges. yay.
thx very much!
would you mind explaining further about the Sum function and why i should use it?
Summary is good for reports where you want to break-out totals by sub-header, etc. but I noticed in some instances that it doesn't always update the total displayed on layouts immediately whereas the function Sum does.
i think in this case i need to use the summary field rather than the Sum total.
the most frustrating part of this process is that i distribute data using IWP, so i think im often learning improperly. or at least creating less than perfect work-arounds.
i appreciate your help!