Complete scenario is like this:
On first day of month and before the extract data is refreshed , report is showing blank columns because of the filter condition which is set to pick the latest value when report is opened.
So in short, on the morning of 1st Nov 2017 , before the extract was refreshed, it displayed all the columns related to monthly stats as blank because there was no data for Nov 2017 at that time and no data coming in means no marks on the canvas.
In these scenarios, where because of filter condition, there is no record coming in and everything getting filtered out, User want to see numeric zero in those columns instead of getting blank column in report.
I have tried all the formulas but they cannot make up for no data coming in on canvas.
Let me know in case you have encountered similar issue and what was the approach you followed.