Hello All,
I have a Chart Table with +40 expressions. Below an example (A to F are expressions)
Now i would like to hide the expression where the sum over all months is 0.
Each expression is like this (with offcourse different FKcodes per expression):
sum({<FKcode={'VD1'}, Bron = {'result'}>} amount)
and in the conditional for each individual expression i could set this (it also includes a variable vShowZero)
sum({<FKcode={'VD1'}, Bron = {'result'}>} amount) >0 or vShowZero = 1
Now I'm getting a performance issue with this table because I'm basically doubling each expression just for the conditional show determination.
Can this be done more efficiently??
Your help would be appreciated.
Regards,
Peter