Filter Current Selection Except one Value

[cristian_av]

Hi

I need to filter the one value from a Sum, but considering the current selection.

Actually, I'm using the following set expression, that excluded the value (ExcludedValue), BUT ignores the current selection on the filter.

=Sum({$<[Tipo Registro]={Real},code_nombre={'*'} - {'ExcludedValue'}>}Pesos

How can I exclude the value without ignoring the current selection??

Thanks!!

[sunny_talwar · Accepted solution]

Try this

=Sum({$<[Tipo Registro]={Real},code_nombre -= {'ExcludedValue'}>}Pesos)

Note: Add the minus sign before the equal sign

[cristian_av]

Thanks.. but it's not working.. that gives me another value.  (Not sure what means -= )

It is working.  A selection was set and because of that the value changes (As expected.. dumb of me)