Video Screencast Help

Formatting Report Data

Created: 21 Nov 2012

Sorry if this is the wrong place to ask if it is please let me know the right place.

I am (for the first time) working on a report in SMC all the data is displaying as I expect.  However I have a price column that gets its data from a decimal field in the DB and displays incorrectly.  I would like 0 to display as £0.00, 56.02 as £56.02 etc.

For the life of me I cannot see how I would do this.  I have looked at advanced formatting but this makes no sense at all and I have to help files that I can find.

Any pointer would be really appriciated.

Many Thanks