Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
How about this?
Count(DISTINCT {<Region = {"=Sum({<status='Actual'>}sales) >= Sum({<status='Target''>}sales))"}, A = {'a'}, B = {'b'}>} Region)