Making balance report more robust against missing data