Substract by

[pgalvezt]

Hello,

I have the following formula:

(sum({<Cuenta={'01020304'}>}Monto_Pesos) /Valor_Factor) - (sum({<Doc={'AM130311000005','AM130311000006'}>}Monto) /Valor_Factor).

There are many more "AM"

In the pivot Appear.

Doc     Monto

A          5000

B          10000

So on

AM130311000005    -90000

AM130311000006    -98777

I would like if its possible subtract all documents beginning with "AL" (Because there are many "AL"). This negative value is shown in the chart but would not appear in the pivot. Only in the final result.

Thanks!

[iktrayanov]

Try this expression

If( Dimensionality() = 0,

Sum({<Cuenta={'01020304'}>}Total Monto*-1 / Valor_Factor), // Then >> this is the total

Sum({<Cuenta={'01020304'}>}Monto*-1 /Valor_Factor)) // Else >> this is a normal cell in the table

[pgalvezt]

Hi,

Dont work, still show -9 Million

Thanks!

[iktrayanov]

Can I see you calculated dimension?

[pgalvezt]

=If(Cliente ='','D',Cliente)

Año

[iktrayanov]

Wait a second. Are we still working on the Removing the documents that start with 'AM' in a pivot table because this looks like something else.

[pgalvezt]

Nop,

This is the only formula, I found another way to put all AM but in the other systems that connect with QlikView. So the AM are incorporate inside the formula.

Sum({<Cuenta={'01020304'}>}Total Monto*-1 / Valor_Factor)

[iktrayanov]

So is this a pivot table? Because it looks like straight table with dimension limits to show only positive values.

[pgalvezt]

Its a pivot table.

[iktrayanov]

Try this in your dimension

=If(Cliente ='','D', If(Cliente<>'OTHROS',Cliente))

[pgalvezt]

I appreciate all your effort but I think its impossible to get What I want. Anyway I give you points for your time.

Thanks!!