Divide By Total

[pgalvezt]

Hi, Independent the formulas works fine

Sum

({<Tramos={'Tramo 0'}>}If(Cod_Bloqueo <> 8, Deuda_Total))/(Sum(TOTAL{<Tramos>}If(Cod_Bloqueo <> 8, Deuda_Total

)))

But Gave me 1.

The first result gives 17000000

The total Gives 31000000000000.

But is not calculating the real.

Thanks

[erichshiino]

Hi,

Which dimensions do you have in your chart?

Maybe you'd like to use

Sum(TOTAL{Tramos}If(Cod_Bloqueo <> 8,Deuda_Total

)

as your second expression or

Sum(TOTAL{<Tramos = >}If(Cod_Bloqueo <> 8,Deuda_Total

)

You can also remove the if condition and use it as a set analysis:

Sum

  ({<Tramos={'Tramo 0'}, Cod_Bloqueo-={8}>} Deuda_Total)

and

Sum

  ({<Tramos={'Tramo 0'}, Cod_Bloqueo-={8}>} total Deuda_Total)

Hope it helps,

Erich

[pgalvezt]

Hi, Thank you for your reply but still gives 1. It's as if I were dividing system 370000/370000.

Operates separately formulas. A formula giving the leg and the other gives me the total but when I get one split.

Thanks

[pgalvezt]

Sorry I found the problem my formula was fine. It was a format numeric problem now works.