it would be good if you post the sample workbook.
Hi Tharashasank - Thanks for the quick reply. It turns out its an issue with Excel that was an easy fix.
To change blank cells (or Nulls) to 0, use the 'Go To Special' function.
Doing this will return the cells as a number in Tableau for aggregation.