Your original report will only show VMs that have at least 1 snapshot.
The VMs requiring consolidation most probably do not have any snapshots, that is probably the reason you do not see any value in that column.
Did my previous short script show any VMs requiring consolidation ?
Do any of these VMs have snapshots ?
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference