Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have expression like:
Sum(
{<
Region = {"USA", "Asia"}
>}
Sales)
How do I make this expression to respond to the filter Region Asia?
Thank you!
Hi,
May be
Sum({<Region = {'Asia'}>} Sales)
What you mean by expression to respond ? if you want the expression to respond for filter you apply simply try like this
Sum(Sales)
if you want the expression to remain constant for the Asia then use Sum({<Region = {'Asia'}>} Sales)
May be this?
Sum(
{< Region *= {'Asia'}>+< Region = {'USA'}>}
Sales)
try this
Sum(
{<
Region *= {"USA", "Asia"}
>}
Sales)
Thank you for your answers.
I have just decided to make a trigger for my issue.
None of our solutions work? Or we misread your requirement?
You should avoid triggers as far as possible. Solution suggested by me or Tresesco should work