Set Analysis problem

[pgalvezt]

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.

[MayilVahanan]

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.

[pgalvezt]

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

[pgalvezt]

Any Help?

Thanks!

[pgalvezt]

Anyone can help me with this?

Thank you!

[#6]

Try:

If(Cod_Bloqueo <> 8 and Tramos='Tramo 0', (Deuda_Total))/Divisor) - (Sum(Saldo_Cob)/Divisor) - (Sum(Saldo_Dic)/Divisor) -(Sum(Saldo_Susp)/Divisor)

[#7]

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)

[pgalvezt · Accepted solution]

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))