Count of regions who has achieved 100% Sales

[janarthanan_rb]

Hi,

I want to calculate the number of regions who have achieved 100% sale by comparing the target value.

Both sale and target values are derived from the expression.

Many thanks in advance

[sunny_talwar · Accepted solution]

May be like this:

Sum(Aggr(If(Sum(Sales)/Sum(Target) >= 1, 1, 0), Region))

[swuehl]

Could you be more specific about your model, expression context and how you derive sales and target?

Maybe something like

=Sum( Aggr(If( Sum(Sales) = Sum(Target),1), Region))

could work.