Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Need Calculation help.

I have an odd SLA calculation I am trying to build and it just doesn't seem to work.   I have a Completion Percentage.  Example: Job 1 uses 5 of 10 allotted days.  It therefore meets SLA. Job 2 ...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    Anonymous I guess you need this:

     

    1-
DIVIDE(
   SUM('TABLENAME'[Days to Complete]),
   SUM('TABLENAME'[ALLOCATION SLA Days])
)
parry2k's avatar
parry2k
Super User
2 years ago

Anonymous I guess you need this:

 

1-
DIVIDE(
   SUM('TABLENAME'[Days to Complete]),
   SUM('TABLENAME'[ALLOCATION SLA Days])
)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you. Yes, that is what I was looking for.  Moving the -1 to before the DIVIDE function.