Skip to main content

Hi all, I'm encountering an issue when filtering out top 5 and bottom 5 projects. Using my calculations, I get null values, when filtering out the non-null values and using my filter to give me top 5 projects and bottom 5, it does take into account the null-values, so I'm not getting a correct top & bottom 5. Any help would be very much appreciated. Please find attached worbook with a similar dataset

 

Thanks!

1 answer