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?
In a filter slice the computers that are inoperative.
I would like to see how long they remain inoperative in days
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)
but can i add this formula olso in a virtual column?
Yes you can. It’s an expression at the end.