Crow Canyon Software Forum

Forum Navigation
Please or Register to create posts and topics.

How to format the total of an associated column?

Is there a way to format the Total of the Associated Column to add comma as the separator? The current format we are using is '$'+Number(%value%).toFixed(2) but this is not showing commas

Uploaded files:
  • format-associated-column-total.gif

I actually found the solution after I posted this, so - if anyone is looking - this is what we used for the format:

Number(%value%).toLocaleString('en-US',{style: 'currency', currency: 'USD',})

 

Brian.