Hey i am using aggregate calculated values to chart i want to use EmptyPointBehavior to generate chart .
when i have null value in any of the aggregate calculated fields i want to use EmptyPointBehavior.Gap property to chart
i am able to accomplish it with normal column values but i am unable to do that with aggregate values because it is not taking NULL values
if it is NULL it is taking its default blank.
<telerik:GridViewDataColumn Header="Cost Per SqFt" DataMemberBinding="{Binding CostPerSqFt,Converter={StaticResource NullToStringConverter}}" UniqueName="CostPerSqFt">
<telerik:GridViewDataColumn.AggregateFunctions>
<Model:TotalCostPerSqFtAggregateFunction Caption="Total Cost Per SqFt:" ResultFormatString=" {0:#}" />
<Model:CostPerSqFtAggregateFunction Caption="Average Cost Per SqFt:" ResultFormatString=" {0:#.##}"/>
</telerik:GridViewDataColumn.AggregateFunctions>
</telerik:GridViewDataColumn>
This is my code in that i used Converter={StaticResource NullToStringConverter}} to get NULL values to grid but i am unable to do that for
AggregateFunctions Fileds.
i have a custom aggregate function which returns NULL.
when i have null value in any of the aggregate calculated fields i want to use EmptyPointBehavior.Gap property to chart
i am able to accomplish it with normal column values but i am unable to do that with aggregate values because it is not taking NULL values
if it is NULL it is taking its default blank.
<telerik:GridViewDataColumn Header="Cost Per SqFt" DataMemberBinding="{Binding CostPerSqFt,Converter={StaticResource NullToStringConverter}}" UniqueName="CostPerSqFt">
<telerik:GridViewDataColumn.AggregateFunctions>
<Model:TotalCostPerSqFtAggregateFunction Caption="Total Cost Per SqFt:" ResultFormatString=" {0:#}" />
<Model:CostPerSqFtAggregateFunction Caption="Average Cost Per SqFt:" ResultFormatString=" {0:#.##}"/>
</telerik:GridViewDataColumn.AggregateFunctions>
</telerik:GridViewDataColumn>
This is my code in that i used Converter={StaticResource NullToStringConverter}} to get NULL values to grid but i am unable to do that for
AggregateFunctions Fileds.
i have a custom aggregate function which returns NULL.