Conditional Formatting of Currency or PCT

[mikep]

I need to format a cell as currency or integer, based on the value of another column in the row.
I want to maintain the functionality that when the cell is selected to edit, the "$" is removed when editing the cell.

How would I do that?

[paramvir]

you would use the column.render to conditionally format a cell depending on the value of another column.

Code: [Select]

render: function( ui ){
  if(ui.rowData.another_column_dataIndx == some_value ){
    //format as currency.
  }
  else{
    //format as number.
  }
}

and you can use the formatNumber for formatting: https://paramquery.com/pro/api#method-formatNumber

[mikep]

Thanks, I got that far. What do I put for //format as currency?

"format: '$#,###' " is what I'm looking for, but this seems to only work when defining the column, but not during render. I need it during render, since its conditional based on the row.

[paramvir]

You don't need to use column.format but call pq.formatNumber method with required format as parameter and return the formatted string from column.rernder

[mikep]

Thank you. Can you correct this. the 2 options below dont work.

render: function( ui ){
  if(ui.rowData.another_column_dataIndx == some_value ){
    //format as currency.
    return { pq.formatNumber(1200, "$#,####")  }
  }
  else{
    //format as number.
   pq.formatNumber(1200, "#,####")
  }
}

[paramvir]

You need to substitute pseudo code with actual conditions i.e, another_column_dataIndx  is to be replaced with actual dataIndx

and you also need to return the formatted value in case of number.

[mikep]

I understand that. I need the syntax to do the actual formatting in the render, the below 2 lines don't work.


return { pq.formatNumber(1200, "$#,####")  }

pq.formatNumber(1200, "#,####")

[paramvir]

That would be

Code: [Select]

return pq.formatNumber(1200, "#,####");


[mikep]

Thank you. I also need to format the summary cell. I'm always getting the currency format

[paramvir]

Same logic applies to summary cells. Please share a jsfiddle if facing issues.