chart problem

[#1]

Hello everybody,

I have a little problem with the expression of my chart. I want to have the total of my expression 'IS' but with aggr() fonction it doesn't work! (I think it's because I have a log() in my expression!?).

I want to have the total in total case or in all case as my precedent expression. I have the same problem for the two charts of my qvw.

I put my qvw in attach, perhaps you can help me?

Thank you a lot and have a good day

Budny Quentin

[Gysbert_Wassenaar · Accepted solution]

Try:

=sum(aggr((( sum(comptage)/sum(total <lib_var,MOI_DEC>comptage))  -   sum(valeur_calcul) )

*

log(   ( sum(comptage)/sum(total <lib_var,MOI_DEC>comptage) )  /    sum(valeur_calcul)   )

,lib_var

,valeur

,valeur_calcul

,MOI_DEC))

[#3]

Beautifull Gisbert,

It's exactly what i want!!!!!

Thank you so much,

Quentin