I need to show by counselor how many students were accepted, cancelled, enrolled, etc. I also need grand totals. I tried using a calculated field where I entered:
iif(trim(query.dispos) eq DE("Accepted"), 1, 0) in the perform calculation on field but I always get 0 for the answer. I tried using single quotes around Accepted but that didn't make a difference.
Is "Accepted" a field in your result set?
Yes it is.
300 E. College Avenue
Eureka, IL 61530-1500
On Mon, Jan 26, 2015 at 4:57 PM, Eddie Lotter <firstname.lastname@example.org>
Then don't use the delay evaluation function. Change your code to the following:
iif(trim(query.dispos) eq query.Accepted, 1, 0)
However, if you are trying to determine its value then use the following:
iif(trim(query.dispos) eq "Accepted", 1, 0)
Thank you for your help!