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]

Then you need this one I believe:

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

and I believe this one will also work:

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

[Anonymous]

Hi Anees,

please try below:

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

Regards

Neetha

[#4]

Nop, That too didnt worked.

[Anonymous]

please can you elaborate on your requirement and post sample data if possible.

Regards

Neetha

[jonathandienst]

I think you should post a sample. Some attempt by yourself at a diagnosis or specifics of how they did not work would also help.

Something else to try:

=Sum({1 - <percentage = P(percentage), amount = P(amount)>} amount)

=Sum({1 - <percentage = P(percentage), amount = P(amount)>} percentage)

[Anonymous]

hi anees,

may be try:

=Sum({<percentage -= percentage, amount -= amount>} amount)

=Sum({<percentage -= percentage, amount -= amount>} percentage)

Regards

Neetha