Index outside the bounds of array

The IIF statement you included would not run as you currently have it set. The syntax for IIF is: IIF(expr, true, false). This may just be due to pasting issues from your report, but your 1st IIF Statement has an extra section, and the 2nd does not have anything in the False result portion.

Also your stack trace screenshot does not include the error message. Try finding the entry that has an entry under the “Exceptions” tab, as that should give you more information on the specific error.

Are you using this in a report section (such as visibility expr), or in a text box on the actual report? It seems like on the actual report as there are output values, but you likely will also want to combine the OR parts of your statement into the False section of your 1st IIF statement:

IIF( True and Label = ‘XXX’, ‘X’, IIF(False and Label = ‘XXX’ , ‘Y’,’Z’))

Alternatively you could do something like:

IIF(Label = ‘XXX’, iif(Included = True, ‘X’, ‘Y’), ‘Z’)

There are normally multiple different ways to ‘chain/nest’ IIF statements that can be pretty powerful, a lot depends on your data classes involved and your end goal.