Total days

[smilingjohn]

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.

Thanks in advance 

[MatheusC]

Olá @smilingjohn 

tente Count (distinct Período Data)

[Or]

alt(ClosedDate,today())

[smilingjohn]

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 

[Aurelien_Martinez · Accepted solution]

Hi,

Like @Or said :

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

Aurélien

[Or]

alt(ClosedDate,today()) 😉

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