Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i am trying to calculate the difference from the last modified date to present date..(today) i have attach an image of the data table that i am using.. as an output i need to take a count of all the incidents that is in the "pending " state more than 10 days.. can some one plz help me with this really really would appreciate the help
thank you in advance
try this..
Count(IF((today()-SMod_date)>10 and status='pending',IncidentID)
Can you provide your sample data in excel file?
In the backend create a new field if((Today() - SMod_Date)>10,1,0) AS NoOfDays
Use
SUM({$<status={'pending'}>}NoOfDays)
count( distinct if(Status='In Progress' and interval(today(),S_Mod_Date,'DD')>10,[Incident ID])
hope this helps
=Count(If(Interval(Today()-S_Mod_Date,'D')>10 and Status='In Progress',IncidentID,Null()))