Topic: Tablegrid Column Formatting
Hi,
I have a calculated field that contains currency values that i need to display in a tablegrid column in a specific format.
Example:
VALUE VALUE
£324.35 not 324.35341
£4,356.67 not 4356.66845
Can you tell me the best way to
a) format the column with a '£' currency sign
b) format the column using a ',' as a thousands separator
c) format the column to 2 decimal places.
Thanks,
Derek.