Average weight of a table

[philgood34]

Hello,

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 ?

Thanks

[philgood34]

Yes of course

but i don't know how send the file ... sorry

[sunny_talwar]

Check here

Uploading a Sample

[philgood34]

thank's

here is the file

[sunny_talwar]

Check this out

Expression

If(Dimensionality() = 0, Sum(Aggr(Sum(CIB_MBTVTE)*Sum(VMS_CAHT), NCL_LIB))/Sum(VMS_CAHT), Sum(CIB_MBTVTE))

[philgood34]

GREAT JOB !

i 'll study these expression to be able to reproduce ...

thank's a lot

see you !