Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
This is the formula I want to use in a pivot table.
count( if(
(Status_Incidents='Closed' or Status_Incidents='Resolved'
or (Status_Incidents='Waiting' and [Assignment Status]<>'Completed')),Status_Incidents,
if((if((count(if([Assignment Status]<>'Forwarded', [Incident #])))=0,'Forwarded',
if((count(if(([Assignment Status]='Waiting' or [Assignment Status]='Accepted'), [Incident #])))=0,'Completed',
if((count(if([Assignment Status]='Accepted', [Incident #])))>0,'Accepted','Waiting')
)
))='Completed', InCompleted',Status_Incidents)
))
It is showing the error "Nested Aggregation Not allowed".
I dont think if I can use Aggr because of the conditions used.
Can anyone help me on this?
This is the criteria from Excel
=IF(OR(M85="Closed",M85="Resolved",AND(M85="Waiting",BC85<>"Completed")),M85,IF(BC85="Completed","TEK Completed",M85))
where
M85=Status
BC85==IF(BA85=0,'Forwarded',IF(BB85=0,'Completed',IF(AY85>0,'Accepted','Waiting')))
BA85==COUNTIFS(ASSIGNMENTS!$A$2:$A$5000,B85,ASSIGNMENTS!$C$2:$C$5000,"<>Forwarded")
BB85==AX85+AY85
AY85==COUNTIFS(ASSIGNMENTS!$A$2:$A$10000,B85,ASSIGNMENTS!$C$2:$C$10000,"Accepted")
AX85==COUNTIFS(ASSIGNMENTS!$A$2:$A$10000,B85,ASSIGNMENTS!$C$2:$C$10000,"Waiting")
B85=Incident #
can you share a sample in excel?
also what is this count for , Resolved?Waiting?/Active?