Count()

[mahitham]

Hi Experts,

Can any one please help me on Below requirement.

I have created a Straight Table like below.

From [Internal ID]  and  New Performance ID fields I have to calculate Count of NOT AVAILABLE  [Internal ID]'s.

Please help me on this

Thanks in advance.

[brunobertels]

Hi

May be this

if(

ISNULL(AGGR(

if(Match([Sales Product],'TV'),[Performance External ID],

if(Match([Sales Product],'Mobiles'),[Performance ID])),

[Internal ID])),count([Internal ID])

[sunny_talwar]

When you say not available... is the data stamped with not available or it is just null?