Distinct Count of Region for target completed.

[jegadeesan]

Hi All,

I have to count  target completed distinct regions .

No of regions which has sales greater then its target of sale.

Am trying with below given expression but not getting expected one.

if(A='a' and B='b' and ((sum({<status='Actual'>}sales)/1000)

>=

((sum({<status='Target''>}sales)/1000))),count(distinct(Region))

Regards,

Jegadees.

[sunny_talwar]

How about this?

Count(DISTINCT {<Region = {"=Sum({<status='Actual'>}sales) >= Sum({<status='Target''>}sales))"}, A = {'a'}, B = {'b'}>} Region)