Casting in GridCalculatedColumn - Possible?

[Marcus]

Hello All,

I'm trying to calculate a percentage in a GridCalculatedColumn, but both input types are integer, so the return value is incorrect (an int formatted as %, which results in 0%, 100% 200% etc.)

Is it possible to cast the value in the expression, or do I have to do it the hard way using itemdatabound or similar?

markup:
<telerik:GridCalculatedColumn DataFields="totalNo,UsedNo" HeaderText="Allocated" DataType="System.Decimal"
Expression="({0} / {1})" ColumnGroupName="Compute" DataFormatString="{0:P}" />

I tried "(Convert.ToDecimal({0}) .... but that gave me errors.

Thx in advance!
M.

[Attila Antal]

Hi Marcus,

The Calculated column will take into account the type of data of the fields. For instance, the fields bound to RadGrid will need to be of the correct type if you're looking to work with decimals.

Then you can use an expression to calculate the numbers you need.

<telerik:GridCalculatedColumn DataFields="totalNo,UsedNo" HeaderText="Allocated"  Expression="({0} / {1})" ColumnGroupName="Compute" DataFormatString="{0:P}" />
<telerik:GridCalculatedColumn DataFields="totalNo,UsedNo" HeaderText="No Data Formatting"  Expression="({0} / {1})" ColumnGroupName="Compute"  />

 

Result

 

You can also format that in the code behind and change the cell's values programmatically, see Accessing Cells.

 

Kind regards,
Attila Antal
Progress Telerik

[SMc]

I think the correct Expression should be to get a percentage: 

Expression="({1} / {0})"