Calculate Number of Days

[bhmiller89]

I successfully calculated the length of a project for both completed projects and projects that are still active: 

LengthDays = IF('dpmgr vwJMWebJobSummary'[POStatus]= "Order Complete", 'dpmgr vwJMWebJobSummary'[CloseDateActual]- 'dpmgr vwJMWebJobSummary'[CreationDate], IF('dpmgr vwJMWebJobSummary'[POStatus]= "Order Execution", TODAY()- 'dpmgr vwJMWebJobSummary'[CreationDate], 0))

I created a second calculated column to show actual days worked by using

= SUM(Hrs Entered TD)/ 8

However, I get a really big number that doesn't really show me anything.  Basically, I want to compare the calendar days the job was / has been open and compare it to taking the total amount of time entered against a job divided by 8 hours (1 day) 

[v-ljerr-msft]

@bhmiller89

---

I created a second calculated column to show actual days worked by using

= SUM(Hrs Entered TD)/ 8

However, I get a really big number that doesn't really show me anything.  Basically, I want to compare the calendar days the job was / has been open and compare it to taking the total amount of time entered against a job divided by 8 hours (1 day) 

---

What is "Hrs Entered TD"? Is it a column in the table or it is just a measure? Without knowing what "Hrs Entered TD" is and your table structure, it may be difficult to help. So could you post some sample data in your case?

Regards