Obtain Total

[pgalvezt]

Hi,

I have to change nums into the fields so I have this:

=Aggr(if(var='1' and codigo='84',7809,if(var='2' and codigo='84',4500000,if (var='2',sum(actual) ,sum(actual1)))),codigo)

So I need to change the cod value (works fine) the problem is that still show the same Total. If a change year for codigo show the total but dissapear the first 2 values.

[Anonymous]

could you elaborate may be with screenshots and sample file?

[pgalvezt]

I attached sample test with my formula.

Thanks!

[rwunderlich · Accepted solution]

Wrap the whole thing in a SUM.

-SUM(

Aggr(if(var='1' and codigo='84',7809,if(var='2' and codigo='84',4500000,if (var='2',sum(actual) ,sum(actual1)))),codigo)

)

-Rob

[pgalvezt]

Thanks Rob.