Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello, anybody can help to get the real result:
(This Work pefectly)
=(Sum(If(Cod_Bloqueo <> 8, Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor)
But I need the same formula here:
(Doesn't work)
(Sum({<Tramos={'Tramo 0'}>}If(Cod_Bloqueo <> 8, (Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor)
Thank you.
Many Thank to you Rebeccad You gave me a good Idea and now I could solve the problem:
=((Sum(If(Cod_Bloqueo <> 8 And Tramos = 'Tramo 0', Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor))
/
((Sum(If(Cod_Bloqueo <> 8, Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor))
Hi
Did you check 'Tramo 0' is in Tramos? or for that particular field, there may be no data.. So please refer the data once.
Hi, Sorry for the delay. I checked tramo 0 with this formula and works perfect.
(Sum({<Tramos={'Tramo 0'}>}If(Cod_Bloqueo <> 8, Deuda_Total))/Sum({<Tramos>}If(Cod_Bloqueo <> 8, Deuda_Total)))
I need to add the follow:
- (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor)
Thanks
Any Help?
Thanks!
Anyone can help me with this?
Thank you!
Try:
If(Cod_Bloqueo <> 8 and Tramos='Tramo 0', (Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor)
Whoops, one to many parentheses. Try:
If(Cod_Bloqueo <> 8 and Tramos='Tramo 0', (Deuda_Total/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor)
Many Thank to you Rebeccad You gave me a good Idea and now I could solve the problem:
=((Sum(If(Cod_Bloqueo <> 8 And Tramos = 'Tramo 0', Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor))
/
((Sum(If(Cod_Bloqueo <> 8, Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor))