topic Re: Average weight of a table in App Development

Average weight of a table

philgood34 — Thu, 10 Aug 2017 18:01:37 GMT

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

Re: Average weight of a table

sunny_talwar — Thu, 10 Aug 2017 18:43:23 GMT

What is the number you are expecting to see?

Re: Average weight of a table

philgood34 — Thu, 10 Aug 2017 18:57:21 GMT

I'am expecting (23.10%*3822831+15.4%*2875939+28.8%*680411+24.10%*1107559)/8486740 = 21.08%

Re: Average weight of a table

sunny_talwar — Thu, 10 Aug 2017 18:59:38 GMT

Then try this

Sum(Aggr(Expression for % MARGE THEO * Expression for CAHT, SECTEURS))

Re: Average weight of a table

philgood34 — Thu, 10 Aug 2017 19:10:05 GMT

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

Re: Average weight of a table

sunny_talwar — Thu, 10 Aug 2017 19:13:08 GMT

What other options do you see here? Do you see Expression Default?

Re: Average weight of a table

philgood34 — Thu, 10 Aug 2017 19:36:27 GMT

i see

auto

avg

count

max

min

sum

none

but not

expression fx

😞

Re: Average weight of a table

sunny_talwar — Thu, 10 Aug 2017 19:37:29 GMT

Can you check with auto and this expression

Sum(Aggr(Expression for % MARGE THEO * Expression for CAHT, SECTEURS))

Re: Average weight of a table

philgood34 — Thu, 10 Aug 2017 19:41:12 GMT

if i select auto i have no window to write the expression ???

Re: Average weight of a table

sunny_talwar — Thu, 10 Aug 2017 19:49:08 GMT

Would you be able to share a sample qvf file?

Re: Average weight of a table

philgood34 — Thu, 10 Aug 2017 19:56:25 GMT

Yes of course

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

Re: Average weight of a table

sunny_talwar — Thu, 10 Aug 2017 19:57:11 GMT

Check here

Uploading a Sample

Re: Average weight of a table

philgood34 — Thu, 10 Aug 2017 20:00:01 GMT

thank's

here is the file

Re: Average weight of a table

sunny_talwar — Thu, 10 Aug 2017 20:13:54 GMT

Check this out

Expression

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

Re: Average weight of a table

philgood34 — Thu, 10 Aug 2017 20:22:51 GMT

GREAT JOB !

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

thank's a lot

see you !