Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys
I hope all is well.
I need to get the % from 2 Totals : 204/ (204+2816)
heres the expression that I use : % : sum(Column(4))/ sum(Column(4)+Column(5))
Any help please.
Try without the aggregation:
Column(4) / (Column(4) +Column(5))
BTW, which columns in your screenshot are you referring to? Maybe you need to handle NULLs as well, e.g. using Rangesum().
Hi,
try too using names of your column,
column(N°) not so good
regards
Hello Stefan,
I tried without the aggregation but it didn't work. I am refering to the total of Nbr de cas Hors delais 204 and the Total of Nbr de cas dans les delais 2816
my columns are expressions
and what are your expressions ?
the error is in one of the expression, you shoudn't have '-' in 'Nbr cas hors délai' but 0
I think you use if in your expression : if(condition,1)
so in expression % you can't use name of field, but repeat the formula :
sum(if( ,1)) / (sum( ) + sum())
and in this expression : check 'total of expression' and not 'sum of rows'
without the expression difficult to say what's wrong in expression !