I created this table
Unfortunely, the average (22.85%) is not the weighted average as i looking for...
Do you know how do these weighted average ?
What is the number you are expecting to see?
I'am expecting (23.10%*3822831+15.4%*2875939+28.8%*680411+24.10%*1107559)/8486740 = 21.08%
Then try this
Sum(Aggr(Expression for % MARGE THEO * Expression for CAHT, SECTEURS))
I understand your answer (thank's); but as a begginer i don't know where insert these instruction ? Indeed, the total line is automaticly created after the selection as shown :
i can't write an fx ...
What other options do you see here? Do you see Expression Default?
Can you check with auto and this expression
if i select auto i have no window to write the expression ???
Would you be able to share a sample qvf file?
Yes of course
but i don't know how send the file ... sorry
Uploading a Sample
here is the file
Check this out
If(Dimensionality() = 0, Sum(Aggr(Sum(CIB_MBTVTE)*Sum(VMS_CAHT), NCL_LIB))/Sum(VMS_CAHT), Sum(CIB_MBTVTE))
GREAT JOB !
i 'll study these expression to be able to reproduce ...
thank's a lot
see you !
Retrieving data ...