Forum Discussion
Calculating Uptime
Hi,
Try this
=IF(ISBLANK(SUM('Issue'[Downtime])),1,DIVIDE(SUM('Service Reliability (days in month)'[HoursinMonth])-SUM('Issue'[Downtime]),(SUM('Service Reliability (days in month)'[HoursinMonth]))))
Ashish_Mathur
thanks for the help. i still get the same output.
i forgot to add the "Group" column in my example above which defines the service/product
would it be caused that i dont have a sum of that product group for that month? as shown in the sum of each month by "Group" matrix table. essentially the missing gaps means there were no downtime minutes for that month
should i be changing how i sum up this first?
Hi,
I am not sure of how much i can help but share the link from where i can download your PBI file. In that file, please clearly show the result you are expecting to see.
here is the link for the file
https://drive.google.com/open?id=1E-OOUOH2GQhiswg6OBfyX3BsTTFsNEwl
the expected output which i have marked in red are all the blanks in the matrix reports that need a value
so 0.00 would be when i am calculating per month the sum of downtime. if there is no downtime, then i should see 0.00
when i work out the uptime % in the bottom table. i need the calculations to say 100% if there has been no affected downtime for that product for that month,