Power file help

did a FTP test today and it was a solid effort. I noticed though that during the 20-min test that my garmin 500 dropped the signal a handful of times thus skewing the average power and average heart rate data. I am not able to upload the file into garmin connect for some reason but was able to get the file off my device and put it in golden cheetah and training peaks but have no idea how to use either system to hopefully see what my averages are without the zeros. Anyone know how to get the averages without the zeros in it?

nevermind, I figured it out in golden cheetah!!!

In TP just look at NP, that should be very close unless the drop outs were long
.