Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Condition in set analysis

Hi,

Can you help?

I have variable Minimum Amount and Maximum...

What I want is that, I will only display items, with this condition

UnitPrice >= Minimum Amount and UnitPrice <= Maximum Amount

Here's my expression:

sum({<item_unit_price = {'>$(minAmount)'}>} SellOut)

HOW CAN I ADD THE MAXIMUM AMOUNT? Please extend help.

Best Regards,

Bill

1 Reply
Not applicable
Author

Hi,

sum({<item_unit_price = {'>$(minAmount)'},UnitPrice={'<$(maxAmount)'}>} SellOut)

Thanks,

Robinson