Calculate how many days

[Cannone_Cannone]

hello everybody
in a view with name “inop” i have a list with of the means inoperative e the date.
how do I calculate how many days are inoperative?
thanks

[Steve]

Cannone_Cannone:

a list with of the means inoperative e the date

Please clarify.

[Cannone_Cannone]

Excuse me.
In a filter slice the computers that are inoperative.
I would like to see how long they remain inoperative in days

[Steve]

If the out-of-service/inoperative time is in a Date-type column, you can compute the number of days with:

(TODAY() - [DateColumn])

If the out-of-service/inoperative time is in a DateTime-type column, you can compute the number of days with:

ROUND(HOUR(NOW() - [DateTimeColumn]) / 24.0)

[Cannone_Cannone]

Steve:

ROUND(HOUR(NOW() - [DateTimeColumn]) / 24.0)

ok!
but can i add this formula olso in a virtual column?

[LeventK]

@Cannone_Cannone
Yes you can. It’s an expression at the end.

[Cannone_Cannone]

Sorry
but when I enter the formula in the virtual column I get this error
Column Name ‘how many days’ in Schema ‘GSE_Schema’ of Column Type ‘DateTime’ has an invalid app formula ‘= ROUND (HOUR (NOW () - [days]) / 24.0)’. Arithmetic expression ‘(NOW () - [Days])’ has inputs of an invalid type ‘Unknown’

[Aleksi]

Your [days] column is probably not a DateTime field.

[Cannone_Cannone]

I confirm that I have a column set to datetime

[Mike_A]

I may be completely off base here, but does your NOW() expression have a space before the brackets? Your post is showing your expression error as NOW_()?

Might not be the cause and just the way the error is reported…

[Cannone_Cannone]

perfect!!! tanks a lot!

[Cannone_Cannone]

one last thing
the virtual column how should I set it?
data, data time, text

[Cannone_Cannone]

There is a way to only count the days when the status column is = “inop”