Include All Zeros

Hello PUG,

The ‘Options’ gear allows a user to toggle “Show Net Zero”. Curious, is there a way to ‘Show All - Including Zero’ for a dimension?

For example, is there a way to see all Customers and their related sales, regardless if there is transactional activity in the selected defined period?

Hi @Mike ,

Phocas will by default show “activity” (meaning records in the DB), so take for the example “show net zero”. This is available because the records are in the system and the measure sums to zero. This means its an immaterial value for the report and you can hide those records with that option.

What you are asking is different, you want Phocas to show everything regardless of if there are records or not. This is possible, you need to change the following menu option: