percentage in the total row of a TCD

[pirotfab]

Hello,

Do you know a formul to get the 1.8% in red?

This formul, in the column "tx E", calculate as : CR / CP

However, it does not work in the Total line..

For information, the fields CR and CP calculate expressions. Not a sum of a single field..

CP = sum(M+CMO+CN)

CR = R * CP / TOT

thanks

Fabien

[Anil_Babu_Samineni · Accepted solution]

May be this?

Sum(Aggr(((R*CP)/TOT) / Sum(M+CMO+CN), POSTE, ARTICLE))

[pirotfab]

With this expression, the result is 11% (10%+1%)

[Anil_Babu_Samineni]

Will you able to provide work file. Can you try this?

Avg(Aggr(((R*CP)/TOT) / Sum(M+CMO+CN), POSTE, ARTICLE))

[pirotfab]

By exercising excel at Qlikview I think there is also an error on the CR column

Thanks

[Anil_Babu_Samineni]

Now, i understand - Can you tell us logic behind?

[pirotfab]

by adding your expression

Sum(Aggr(((R*CP)/TOT) / Sum(M+CMO+CN), POSTE, ARTICLE))  in the CR column,

it's ok

thanks for your help