IFS/IF expression for list result does not work

[T_Vi_t_Trung]

I’m trying to create custom report with some expression to let the list callback from some tables but unfortunately the list does not work when its wrapped by IF/IFS

my form script like this:

Expression 1: opt1/opt2/opt3
result =>
wrapping expression:
ifs(
expression1 = opt1,
select(table1[col], condition),
expression1 = opt2,
select(table2[col], condition),
…
)
You can see the list result in report revReport_fixDate section. I’m sure that I have data in the table what I select and the condition of select formular is work already when I move it out of IF/IFS wrapper

Im trying to do this because I dont want to expand alot of virtual column in this table. I have 4 - 6 tables to create custom reports, it will spend alot of times