If Problem

[pgalvezt]

Hello,

I have calculated a formula but I stuck:

Sum(Aggr(

if(Column(8) = 0,

If(Column(6) > 0,

If((aggr(Sum(cantidad_oh),articulo) - aggr(Sum(patrimonio),articulo)) > Column(6),

If((aggr(Sum(cantidad_oh),articulo) - aggr(Sum(patrimonio),articulo)) <= (2*Column(6)),

(((Sum(cantidad_oh) - Sum(patrimonio)) - Column(6))), Column(6)),'0'),'0'),'0'),articulo))

The result gives nothing just a 0.

Thanks!

[#2]

Hey Pablo,

Is it possible to attach a dummy file with some sample data.

Thanks

AJ

[pgalvezt]

Hi,

Sure, Here is the attached. I just almost get all columns. The rest is just Column(A) * Column(B)

Thanks!

[Anonymous]

Hi Pablo,

I thought we've solved a similar problem already - I had to replace references to columns with actual expressions.  See attached with your new problem fixed.

(I also moved totals on top to avoid scrolling)

Regards,

Michael