I have a query with groups and want to do a summary of an attribute Total_Value, the default format of which is as currency with the currency symbol taken from the locale,
so each line is correct as £xxx.xx or $xx,xx or whatever, but the summary contains no currency symbol and lots of decimal places as in 192.05999999901. I've searched the manuals and this forum and can't see a way of replacing {value} with something that will give me what I need which would be £192.06
Can this be achieved?
