Announcements
cancel
Showing results for
Did you mean:
Specialist

## Total days

Hi All,

I am trying to find out the total number of days for a tickets is opened or it got closed .

to do so I am using  the below formula

Num(CreatedDate-ClosedDate)

the above expression is giving me the right days the ticket gets closed ... But there is a scenario where  there is a createdDate and the ticket is still not closed  therefore it should show the total days till today , Please refer below screenshot for reference . I want to display the total number of days from created date when there is no Closed date.

How can I achieve this.

Labels (4)

• ### Set Analysis

1 Solution

Accepted Solutions
Partner - Specialist II

Hi,

Like @Or said :

Num(CreatedDate-alt(ClosedDate,today()))

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!
5 Replies
Specialist

Olá @smilingjohn

tente Count (distinct Período Data)

Did you find a solution to your question? Mark the solution as accepted and if you found it useful, press the like button!
MVP

alt(ClosedDate,today())

Specialist
Author

Hi Champion,

I think I was not able to explain you properly .

With the current formula I am getting the total number of days but I am nt getting the total days when the closed date is null . It should show me the days from created date till today please refer below screenshot

Partner - Specialist II

Hi,

Like @Or said :

Num(CreatedDate-alt(ClosedDate,today()))

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!
MVP

alt(ClosedDate,today()) 😉

This just means if ClosedDate is null, use today's date instead.