P() y E(), ignore selections

[#1]

Hello community!

In the attached image(grilla) you can see a table where i want to show in the Total SOW colum, the sum of all Instituciones columns, but independent if there is any value selected in the list box of Instituciones.

All the Instituciones and Total SOW columns are expresions, so the closer expression that i reach was:

sum(DISTINCT{1< NombreInsitucion_SOW = p(NombreInsitucion_SOW)>}  MontoUSD_SOW)

But the problem with this expresion is that ignore the Instituciones selection and shows all the "Cliente" data set.

Any question where i can help about the problem, let me know!

Thanks in advance!

[sunny_talwar]

If I understand you might need to add p(Cliente) also so that the expression doesn't ignore any selection in that field.:

May be try this:

=Sum(DISTINCT{1< NombreInsitucion_SOW = p(NombreInsitucion_SOW), Cliente = p(Cliente)>}  MontoUSD_SOW)

HTH

Best,

Sunny

[ramoncova06]

you can use the exclusion inside of the "P" or "E" or tell it to ignore the selection itself

sum(DISTINCT{< NombreInsitucion_SOW = p({1<NombreInsitucion_SOW =>})>}  MontoUSD_SOW)

[swuehl]

Have you checked the spelling of your field names in the set modifier?

[#5 · Accepted solution]

Thanks for the replies guys!

I tried your expressions but it returns bigger values, so probably is including some null values of another dimension that i'm not considering.

So, this is the expression that i decided to use.

sum({< NombreInsitucion_SOW=>}  MontoUSD_SOW)

Thanks again for the advices!

Bernardo