Distinct Count of Region for target completed.

jegadeesan — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Distinct Count of Region for target completed.

sunny_talwar — Mon, 12 Sep 2016 15:47:13 GMT

How about this?

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