Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Sorry I found the problem my formula was fine. It was a format numeric problem now works.