I know there are lots of different options using the Format String, but I can’t get it to work properly in the instance that I am using. I am trying to display a dollar figure with 2 decimal points on a report, which in itself isn’t that difficult, BUT I am including it in a Text String. Here’s what I have. SourceExpr = ‘Average Price of $’ + format(AveragePrice) I need AveragePrice to be x.xx. I’ve tried to use string but I get an error Type conversion is not possible blah blah… I know this is probably a no brainer, but I’m having a brain block today. Thanks.
Maybe you can try this: FORMAT(AveragePrice,0,’<Precision,2:2><Standard Format,0>’)
Work like a charm…thanks.