4 Replies Latest reply: Dec 24, 2014 7:30 AM by Enrique Colomer

# Percentage by total

Hello!

I have tried to obtain the percentage by total. Sum(Monto)/Sum(TOTAL(Monto)) but doesn't work

also I tried Sum(Monto)/Sum(TOTAL(<Dimension>Monto))

 2013 2014 279.546.344 265.724.196 4,91% 284.068.632 50.038.435 4,99% 2.461.684.247 2.396.134.301 43,25% 1.017.790.251 1.052.756.852 17,88% 58.968.103 39.347.902 1,04% 53.482.772 46.779.317 0,94% 1.254.410.643 1.673.510.430 22,04% 93.477.680 25.073.305 1,64% 76.939.347 170.740.111 1,35% 111.378.982 61.719.825 1,96% 5.691.747.001 5.781.824.674

Thanks!

• ###### Re: Percentage by total

Try an expression of

Sum(Monto)/Sum(TOTAL <Periodo> Monto)

You also have loads of rows where [Activo_Circulante]  is null so untick Suppress When Value Is Null from it on the dimension tab.

• ###### Re: Percentage by total

Hi,

Try like,

Sum(Monto)

/

SUM(TOTAL<Periodo> Monto)

*100

and change format from number tab.

Regards

• ###### Re: Percentage by total

See this.

• ###### Re: Percentage by total

See this: