Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi community
Is there another way to write this expression as this is very confusing
Thanks
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.
Thanks @Gysbert_Wassenaar
Can we have this expression in simple form ? It would really help