Formatting Report Data
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.