the attached problem seems easy but difficult to fix for me.
you can do something like this for the third column:
if(Column(1) > 0 and Column(2) > 0, sum(VAL1)/sum(VAL2) , null())
And change the total mode of the third expression to be "Average of Rows"
Tried and it wont work.
In fact, even if it work, i can't use it. because i'm needing the total to plot a line chart.
the table is just to test out the formula...
Is 500% the total wanted in the TOTAL row (first one)?
Use this expression then:
Hope it helps.
Thanks for the suggestion.
But in fact, i'm trying to get 250% percent.
meaning, the values i wanted to take into account are Feb and Mar, because both val1 and val2 are not 0.
Retrieving data ...