issue with total

[#1]

Hi,

the attached problem seems easy but difficult to fix for me.

Some help?

[#2]

Hi Nick,

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"

Stefan

[#3]

Hi Stefan,

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... 

[#4]

Hi Nick,

Is 500% the total wanted in the TOTAL row (first one)?

Use this expression then:

sum(VAL1/VAL2).

Hope it helps.

[#5]

Ola Borja,

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.

thanks.