Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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])
When you say not available... is the data stamped with not available or it is just null?