Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks ,
Below is my calculated expression for Ticket Age :
=if(IsNull(if(%ClosedDate < 2958465, date(%ClosedDate))),floor(today()-(date(%OpenedDate))),floor((if(%ClosedDate < 2958465, date(%ClosedDate)))-(date(%OpenedDate))))
Now my requirement is not to include Sat, Sun in this calculation , want Ticket Age based on only 5 working days.
Kindly suggest!
Thanks,
AS
May be like:
if(IsNull(if(%ClosedDate < 2958465, date(%ClosedDate))),
floor(Networkdays((date(%OpenedDate),today()))),
floor(
(if(%ClosedDate < 2958465, Networkdays(date(%OpenedDate),date(%ClosedDate))))
)
)
Hi,
You can use NetWorkDays Function.
Nandkishor,
I have already tried this but getting ' - ' values.
Thanks,
AS
May be like:
if(IsNull(if(%ClosedDate < 2958465, date(%ClosedDate))),
floor(Networkdays((date(%OpenedDate),today()))),
floor(
(if(%ClosedDate < 2958465, Networkdays(date(%OpenedDate),date(%ClosedDate))))
)
)
Thanks Tresesco