Understanding

[smilingjohn]

Hi Community,

Can anyone please explain me how the below expression works ? which is the first condition it starts ?
Please need help on understanding this .

=if(IsNull(Dept_Log),

Count(if(Floor(ArrivedDate)=Floor(RecievedDate),Ticket)),

Count({<Dept_Group_log=P(Dept_Log)>}if(Floor(ArrivedDate)=Floor(RecievedDate),Ticket))) 

Thanks in Advance

[smilingjohn]

Hi community

Is there another way to write this expression as this is very confusing 

Thanks

[Gysbert_Wassenaar · Accepted solution]

It counts tickets that have the same ArrivedDate as RecievedDate. In case there is a Dept_Log value for the ticket it will count the tickerts where the Dept_Group_log value is the same as one of the possible Dept_Log values for that ticket. If there is no Dept_Log value for the ticket it will simply count the ticket if the ArrivedDate is the same as the ReceivedDate.

[smilingjohn]

Thanks @Gysbert_Wassenaar 

Can we have this expression in simple form ? It would really help