Folks,
Environment Radgrid for Asp.net Ajax 2010_2_826, VS 2008 SP1.
In my Radgrid I have 3 columns. Salary, ExperienceDifferential and GrossSalary (CalculatedColumn).
I would like to have that CalculatedColumn be populated with the sum of columns Salary and ExperienceDifferential whether these 2 columns are null or not. What I noticed if ExperienceDifferential is null, the CalculatedColumn does not populate, but if ExperienceDifferential is not null CalculatedColumn does populate. Question is in order for CalculatedColumn to work, does other related columns must be not null?
Below is my column declarations and attached is the result set.
Thanks
GC_0620
___________________
<
telerik:GridTemplateColumn
DataField
=
"Salary"
DataType
=
"System.Decimal"
HeaderText
=
"Salary"
SortExpression
=
"Salary"
UniqueName
=
"Salary"
>
<
ItemTemplate
>
<
asp:Label
ID
=
"SalaryLabel"
runat
=
"server"
Text='<%# Bind( "Salary","{0:N2}") %>'></
asp:Label
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"ExperienceDifferential"
DataType
=
"System.Decimal"
DataFormatString
=
"{0:N2}"
HeaderText
=
"Experience Differential"
SortExpression
=
"ExperienceDifferential"
UniqueName
=
"ExperienceDifferential"
>
</
telerik:GridBoundColumn
>
<
telerik:GridCalculatedColumn
DataType
=
"System.Decimal"
DataFormatString
=
"{0:N2}"
DataFields
=
"Salary,ExperienceDifferential"
Expression
=
"{0}+ {1}"
HeaderText
=
"Gross Salary"
UniqueName
=
"GrossSalary"
Aggregate
=
"Sum"
>
</
telerik:GridCalculatedColumn
>