Using exclusion logic for two different fields in a single expression.

[#1]

I have got two expressions:

1.sum({<percentage=e(percentage)>}amount)

2.sum({<amount=e(amount)>}amount)

actually for excluding  the selection of percentage and amount selection.

Can I include it in a single expression.?

Just like :- sum({<percentage=e(percentage) or amount=e(amount)>}amount)

But i think 'or' function wont work in this case, Shed some light on this 🙂

[sunny_talwar]

Try this:

=Sum({<percentage=e(percentage)>+<amount=e(amount)>} amount)

[settu_periasamy]

Hi,

You can use '+' symbol for or expression. Like

=sum({<percentage=e(percentage)> + <amount=e(amount)>}amount)

[#4]

Thank you for your prompt reply 🙂

But its not working

[jonathandienst]

Are you looking for a union (excluded by either percent or amount, or both)

     =Sum({<percentage = e(percentage)> + <amount = e(amount)>} amount)

or are you looking for an intersection (only excluded by both percent and amount)?

     =Sum({<percentage = e(percentage)> * <amount = e(amount)>} amount)

[#6]

I have got two expressions.

=sum({<percentage=e(percentage)> + <amount=e(amount)>}amount)

=sum({<percentage=e(percentage)> + <amount=e(amount)>}percentage)

but only one expression is working.

[sunny_talwar]

Which one is working?

[jonathandienst]

And you would like to guess which one, perhaps?

[#9]

First one is working.. but no change in percentage

[#10]

If I am selecting value 10 for percentage and value 200 for amount, then it should exclude percentage 10 and amount 200 values from that table and should show the rest of the values.

That exactly what I want.:-)