Nested Aggregation Not allowed?

[#1]

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?

[#2]

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 #

[vinieme12]

can you share a sample in excel?

also what is this count for , Resolved?Waiting?/Active?