Hello,
I need to show a bound, numeric column in 2 different formats:
a) the precise amount, e.g. $1,200,900.00b) the same amount recalculated in 1,000-units: T$1,200.9 (= unit "Thousand dollars")
Is it possible to recalculate or reformat this bound column without having to use a hidden or unbound column?
I went back to formatting and unformatting the displayed text and not the underlying value. It can be done by changing the format of the column with these RegEx's:
detailed display: band.Columns[0].Format = "###,###.00"
1000-units: band.Columns[0].Format = "#,##0,.0"; (-> rounding included)