1 of 1 people found this helpful
Is this formula for [Flag 5 Report] close to what you want to achieve?
"Flag " + STR([Flag 1] + [Flag 2] + [Flag 3] + [Flag 4] + [Flag 5])
Since your flags are 1s or 0s, you can just use the following calculation:
sum(zn([Flag 1])) + sum(zn([Flag 2])) + sum(zn([Flag 3])) + sum(zn([Flag 4])) + sum(zn([Flag 5]))
The ZN function is in there to ensure that any NULL is treated as a zero so that we still return a value for that ID. If you try to add a NULL to a non-NULL we will have issues. The ZN protects you against any possible data entry errors.
I hope this helps,
That is ingenious! Thanks so much, that is extactly what I was looking for!