I'm working on a script using Import-Csv to calculate the average of a specific column from an Excel file. However, I'm running into a problem where zeros are being factored into the average calculation, even though I've set up a conditional to filter out numbers that are greater than zero. I'm sharing my script in the comments because the main part of my post keeps getting auto-deleted for some reason.
1 Answer
It sounds like you're overcomplicating things a bit! You can actually calculate the average while excluding zeros by using Measure-Object. Just do this: `Import-Csv $file | Where-Object Score -gt 0 | Measure-Object -Property Score -Average`. The average will be in the output, and it should work perfectly for you.
Thanks! Looks like that fixed it!