Replacing a NaN value with null in DataGrid in flex

Question

<mx:AdvancedDataGridColumn headerText="{Mlc.curr.get('column 1')}" dataField="datafield1" labelFunction="getTotalQty"/>


private function getTotalQty(inData:Object, inCol:AdvancedDataGridColumn):String
        {
            return (isNaN(inData.qty)?"":inData.qty);
        }

currently this returns an empty data grid cell for each cell. irrespective of whether the cell is NaN or has a number in it.

the datagrid is passed several objects, object 0 has NaN and thus returns a null box, object 1 has value 70 and still returns a null box.

Answer 1

inData is a generic object; which probably means that qty is also untyped; as it is not a default property on object. That would be why it fails the isNaN test. Try casting inData to your custom object or casting inData.qty to a Number.

Something like this:

private function getTotalQty(inData:Object, inCol:AdvancedDataGridColumn)
{
            var qtyAsNumber : Number = Number(inData.qty);
            return (isNaN(qtyAsNumber)?"":qtyAsNumber.toString());
}