Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to filter a table by a field, but since I have a formula in an expression that uses another filter, the row that is supposed to be filtered still appears.
The row that does not have to appear is the one that has the value "A2" in "CLAVE" field.
The expression that makes it appear is the following (MARGEN):
Sum( TOTAL<Sector,DescripcionSec,DescAgrupacion,TipoProyecto,DescripProyecto> {<TipoRdo={"CC"}, IdBalance={$(=[IdBalance_PG])}, Clave = {"A58"}>} Saldo)/
Sum( TOTAL<Sector,DescripcionSec,DescAgrupacion,TipoProyecto,DescripProyecto> {<TipoRdo={"CC"}, IdBalance={$(=[IdBalance_PG])}, Clave = {"A2"}>} Saldo)
I attach a screen with the problem.
How can I do to invisibilize it?
Thank you all.
The denominator has this modifier <Clave = {"A2"}> that will make the value "A2" appear.
Y no se podría hacer de otra forma para que no apareciese, con un Aggr o con otro tipo de formula?