Renderer: return usMoney or suppress zero-value

[roedea]

I have a backend RPG program that returns records and one of the fields is a dollar value field. So I have a renderer on the grid field in order to show it as usMoney:

return Ext.util.Format.usMoney(value);

This works great.

However, if the user clicks a checkbox to indicate they only want to see those customers who have more than one record, I only return some basic data like account #, name, and the number of records for that customer... NOT the dollar value field (because it doesn't make sense in this grouped record). In this case, the dollar value field on the grid displays $0.00 and I'd like to suppress that.

So I tried editing my renderer to suppress the value if it is zero, and otherwise return the usMoney:

xtype: 'gridcolumn',
renderer: function(value, metaData, record, rowIndex, colIndex, store, view) {
if(value === 0) return "";
else
return Ext.util.Format.usMoney(value);
},

I don't get an error from what I can tell, but I still see $0.00.

Any ideas? Thanks.

[sean.lanktree]

I am guessing that your back-end response must be passing back a character 0 rather than a numeric.

[roedea]

This is the field I see coming back in the response:

"ZY@AMT":56

So that 56 looks numeric and the usMoney correctly renders it as $56.00.

In the grouped case, I don't return this field at all, and the grid shows it as $0.00

[sean.lanktree]

Either return the field with the value that your "if" condition is looking for or change your "if" condition to compare against an empty value.

[roedea]

Ok, changing the backend to add passing a zero as that field for the grouped scenario works. I added this into the selected fields in my SQL that gets built:

+'0 as ZY@AMT, '+

Thanks.

[Johnny Major]

Another way would have been to have your renderer check if the value is empty.

Example

renderer: function (value) {
    if (Ext.isEmpty(value) || value === 0) {
        return '';
    }

    return Ext.util.Format.usMoney(value);
}

Glad you got it handled.