Data = 0

[pgalvezt]

Hello,

I have a table with many departments and values by Accounts and Cc. I need to appears the other values. When I do clic on 31020301 QlikView Shows 0. Same thing with 31020302. For 31020303 the formula works fine. But I need the other values.

Thanks!!

[sunny_talwar]

I will surely look at it again tonight

[pgalvezt]

Ok Thanks!

I have tried all day. But I cant with this requeriment..

[pgalvezt]

Finally!!

Got it!

Sum(Aggr(

If(Cuenta='31020303' and Subcuenta='' and Cc='4407',Sum({<Año={'2015'}>}MONTO*-1) -

If(Cuenta='31020303' and Subcuenta='' and Cc='4407',Sum({<Año={'2015'}>}MONTO*-1))*0.7513

,Sum({<Año={'2015'}>}MONTO*-1)),Cuenta,Subcuenta,Cc))