Calculated Column with Decimals

[TommyM]

I have a Calculated Grid Column that I am trying to use.  I have in the Expression property "{0}/{1}".  Both fields are of type int, but i want the calculated column to be of type double.  However, when the expression is calculated, the field returns 0.  Any thoughts?

	<Columns>
	<telerik:GridBoundColumn HeaderText="Name" DataField="PlayerName" />
	<telerik:GridBoundColumn HeaderText="GP" DataField="GamesPlayed" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" />
	<telerik:GridBoundColumn HeaderText="AB" DataField="AtBats" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" />
	<telerik:GridBoundColumn HeaderText="R" DataField="Runs" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" />
	<telerik:GridBoundColumn HeaderText="H" DataField="Hits" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" />
	<telerik:GridBoundColumn HeaderText="2B" DataField="Doubles" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" />
	<telerik:GridBoundColumn HeaderText="3B" DataField="Triples" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" />
	<telerik:GridBoundColumn HeaderText="HR" DataField="HomeRuns" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" />
	<telerik:GridBoundColumn HeaderText="RBI" DataField="RunsBattedIn" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" />
	<telerik:GridBoundColumn HeaderText="BB" DataField="Walks" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" />
	<telerik:GridBoundColumn HeaderText="HBP" DataField="HitByPitch" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" />
	<telerik:GridBoundColumn HeaderText="K" DataField="Strikeouts" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" />
	<telerik:GridBoundColumn HeaderText="SB" DataField="StolenBases" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" />
	<telerik:GridCalculatedColumn HeaderText="Avg" DataFields="AtBats,Hits" Expression="{1}/{0}" DataType="System.Double" DataFormatString="{0:N3}" />
	</Columns>

thanks in advance for your help.

Tommy Martin

[Princy]

Hi TommyM,

Please refer the forum link which discuss similar scenario. You can try whether the CONVERT function is working fine for you.
GridCalculatedColumn

Thanks,
Princy.

[TommyM]

Thanks for the reference.  However, I am having the same issue with the Convert method as the other developer in the article.

thanks,

[TommyM]

Actually, I got it working using the following:  Expression='Double({1})/Double({0})

thanks again for your help.