Alert Generation

[rajtechnocraft]

Hi Guys,

I am using the following formula for alert generation.

if(Aggr((Sum(Sales)<=100), Country),Sum(Sales),0)

But i get the value in MSG box always 0

Please help i want to display only those values whose sale value is less than or equal to 100

Thanks

[#2]

Where are you using that formula? Without describing the problem, nobody can help you 😉

However, are you really sure you need the "aggr" keyword? If you are using the formula outside of a chart expression, why you should pre-aggregate by Country?

If you are trying to make Country a dimension of your chart, but want to filter out values "with low sales", so to speak, you could use set analysis in your chart expressions or even your chart dimension:

=Only({<Country = {"=(Sum(Sales) >= 100)"} >} Country)

I just typed this here, so I didn't checked it, but it should work. The idea is to show the Country ONLY where the sum of sales is greater or equal to 100.

Hope it helps.

Bye!

[#3]

Adding some notes: if you want to work on the chart dimension, you should use Aggr(Only(... Country), Country).

If you want to work on the expressions, just copy and paste the Set part beetween {}.

Bye