2100 Clearwater Dr. Suite 330, Oak Brook IL 60523

1-(708) 575-2090 contact@pmsquare.com Visit our other locations: australia singapore philippines

Blog

Cognos Tips – Using Text Variable on a Null/Missing Crosstab Value

The Problem: No Data in the Fact Cells A common requirement that I come across is to have 0 values render in crosstab cells where there is no data at that intersection of the column and row dimensional/attribute data.  This is especially common when the output to Excel (spreadsheetXML) is […]