now after testing I see that there could also be null values, this didn't seem to work
If isnull{ado.Status} or
{ado.Status} in ["AB","D1"] then
1
else
0
If {ado.Status}in ["WTR","WT", ""] then
1
else
0
How would I get a null value also added into the total sum.
Need some help with doing a summary in one of my reports. I have a report that is currently running and giving me correct totals on the groups and a correct summary total. My table has a column in it called “Status”. Status can have 4 values in it, AB, AC, AD or D1. I need to have a count...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.