Copy link to clipboard
Copied
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.
Any ideas?
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)
Copy link to clipboard
Copied
Is "Accepted" a field in your result set?
Copy link to clipboard
Copied
Yes it is.
Bonni
---
Bonni Harris
Database Analyst
Eureka College
300 E. College Avenue
Eureka, IL 61530-1500
309-467-6467
On Mon, Jan 26, 2015 at 4:57 PM, Eddie Lotter <forums_noreply@adobe.com>
Copy link to clipboard
Copied
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)
Copy link to clipboard
Copied
Thank you for your help!