1 Reply Latest reply on Jan 13, 2009 12:27 AM by BaliHi

    Getting NaN in Olap Datagrid

    BaliHi
      Hi,

      I am using the olapdatagrid and am using a date field as a column axis. For the other axis I have an account hierarchy. For the measure I am using a sum aggregator.

      When aggregated the data contains 5 different dates. The problem is that where an account contains values for only some of the dates, the olapdatagrid displays NaN which looks as though there is an error.

      I would prefer it displayed 0 but a blank (as per the Excel Pivot Control) would suffice.

      Any suggestions.