Format GridCalculatedColumn as currency

[jamesh]

I have a GridCalculatedColumn with dataformatstring as currency but it seems not working

                            <telerik:GridCalculatedColumn DataType="System.Double"
                            DataFields="Quantity, UnitPrice" Expression="{0}*{1}"
                            HeaderText="Line Total" UniqueName="LineTotal" ItemStyle-Width="100"
                            DataFormatString="{0:c}" ItemStyle-HorizontalAlign="Right"
                            HeaderStyle-HorizontalAlign="Right">
                            </telerik:GridCalculatedColumn> 

Data on grid shows as "1100.0000". I want it displays as "$11,000.00".  Please help.

[Vlad]

Hi jamesh,

I tried this and everything worked fine - you can check the attached example.

Kind regards,
Vlad
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Scott Topiol]

I have the same problem. It seems it's only occurring when GridCalculatedColumn is used in the GridTableView.

[Pavel]

Hello Scott,

I have prepared a small sample that uses GridCalculatedColumn inside GridTableView. Give it a try and let us know what you think.

Regards,
Pavel
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center