This is a migrated thread and some comments may be shown as answers.

ArgumentOutOfRangeException when we update the cells in the grid

5 Answers 133 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Satrajit
Top achievements
Rank 1
Satrajit asked on 11 Aug 2010, 04:55 PM

Hello,

While testing the edit operations of the code in the grid, I found that when I am complete the Grid row edit ended event, I get the exception as shown below.This exception gets thrown after the code successfully completes its execution of the RowEditEnded or CellEditEnded or any other such Events.I added try and catch blocks within the code for all such events to verify this.

I am using RadControls for Silverlight Q1 2010 SP2.

Please let me know how I can resolve this issue

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.2; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; InfoPath.2; .NET4.0C; .NET4.0E)
Timestamp: Wed, 11 Aug 2010 14:19:32 UTC

Message: Sys.InvalidOperationException: ManagedRuntimeError error #4004 in control 'Xaml1': System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
   at System.ThrowHelper.ThrowArgumentOutOfRangeException()
   at System.Collections.Generic.List`1.get_Item(Int32 index)
   at Telerik.Windows.Controls.GridView.GridViewDataControl.GetRowForItem(Object item, Boolean forceGroupExpand)
   at Telerik.Windows.Controls.GridView.GridViewDataControl.OnCurrentCellInfoChanged(GridViewCellInfo currentCell)
   at Telerik.Windows.Controls.GridView.GridViewDataControl.set_CurrentCellInfo(GridViewCellInfo value)
   at Telerik.Windows.Controls.GridView.GridViewCell.OnGotFocus(RoutedEventArgs e)
   at System.Windows.Controls.Control.OnGotFocus(Control ctrl, EventArgs e)
   at MS.Internal.JoltHelper.FireEvent(IntPtr unmanagedObj, IntPtr unmanagedObjArgs, Int32 argsTypeIndex, String eventName)

Line: 453
Char: 17
Code: 0
URI: http://localhost:5555/rpt/ScriptResource.axd?d=lsm9ZkpLxZCQkQFlNGkKDcRJQJjx9ZiO44TgICWlFv3ITicGoPAQjBmDOf7Hoiv2Iedm-yC8FIGmjX_NthpccA2&t=26f981c1

 

5 Answers, 1 is accepted

Sort by
0
Maya
Telerik team
answered on 11 Aug 2010, 05:07 PM
Hello Satrajit,

Please give us more specifics about your project, its settings and the logic implemented during the RowEditEnded or CellEditEnded events. It would be great if you could send us a sample project illustrating the issue or at least provide us with some code-snippets from your application.
 

Regards,
Maya
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Satrajit
Top achievements
Rank 1
answered on 11 Aug 2010, 05:20 PM
Hello,

Thank you for your response.

The idea that I am trying to implement is that certain columns in the grid have been kept as edtiable and the user edits the cells in such columns and clicks on a submit button to save the data in some application.

However, I find that when the cell edit event completes, it shows the exception mentioned above.

Given below is my xaml page and my XAML page code behind:

=============================XAML PAGE CODE==========================================

<UserControl xmlns:my="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Documents" 
    xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk
    x:Class="Avanade.Crm.Sam.RPT.MainPage"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
    xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
    xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
   

    mc:Ignorable="d" d:DesignHeight="750" d:DesignWidth="12750"
    xmlns:telerik="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls"
    xmlns:telerikInput="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls.Input"
    xmlns:grid="clr-namespace:Telerik.Windows.Controls;assembly=Telerik.Windows.Controls.GridView"
    xmlns:gridView="clr-namespace:Telerik.Windows.Controls.GridView;assembly=Telerik.Windows.Controls.GridView"
    xmlns:data="clr-namespace:Telerik.Windows.Data;assembly=Telerik.Windows.Data"
    xmlns:i="clr-namespace:System.Windows.Interactivity;assembly=System.Windows.Interactivity"
    xmlns:local="clr-namespace:Avanade.Crm.Sam.RPT"
   
    xmlns:telerik1="http://schemas.telerik.com/2008/xaml/presentation">

    <!--
   
    <UserControl.Resources>
        <local:RegionViewModel x:Key="RegionViewModel"></local:RegionViewModel>
    </UserControl.Resources>
       
    -->

<UserControl.Resources>
   
    <Style  TargetType="gridView:GridViewHeaderCell" x:Key="MyHeaderCellStyle">
       
        <Setter Property="Background" Value="LightBlue" />
        <Setter Property="Foreground" Value="Black" />
        <Setter Property="BorderBrush" Value="Black"/>
        <Setter Property="FontWeight" Value="Bold"/>

    </Style>

        <Style x:Key="MyCustomGroupRowStyle" TargetType="gridView:GridViewGroupRow">
           
            <Setter Property="ShowHeaderAggregates" Value="True"/>
           
            <Setter Property="IsExpanded" Value="True"/>
       
        </Style>

    </UserControl.Resources>

    <ScrollViewer HorizontalScrollBarVisibility="Visible">

        <Grid x:Name="LayoutRoot" Background="White">

            <Grid.Resources>
               
                <local:CalculatingConverter x:Key="CalculatingConverter" />
                               
            </Grid.Resources>

            <StackPanel Orientation="Vertical">
               
                <StackPanel Orientation="Horizontal" Margin="0,0,0,5">
               
                    <Image Source="/Avanade.Crm.Sam.RPT;component/Images/logo.png" Width="162" Height="44" HorizontalAlignment="Left" />
                   
                    <sdk:Label Height="28" Name="label1" Width="575" HorizontalAlignment="Left" Content="Revenue Projection Tool" FontSize="20" Padding="50,0,0,0" FontWeight="Normal" FontFamily="Portable User Interface" />
               
                </StackPanel>
               
                <telerik:RadExpander x:Name="radExpander" ExpandDirection="Down" VerticalAlignment="Top" HorizontalAlignment="Stretch" IsExpanded="True" FlowDirection="LeftToRight">
               
                <telerik:RadExpander.Header>
                    <TextBlock x:Name="expanderCaption" Visibility="Visible" Text="Menu" />
                </telerik:RadExpander.Header>
               
                  <telerik:RadExpander.Content>
                 
                  <telerik:RadWrapPanel x:Name="imageContainer" IsAnimated="False" Orientation="Horizontal" VerticalAlignment="Bottom" HorizontalAlignment="Stretch">
                           
                        <StackPanel Orientation="Vertical">                                                             
                               
                                <StackPanel Orientation="Horizontal" Margin="0,0,0,0">

                                    <!--
                                  <telerikInput:RadComboBox Name="radRegionComboBox" Width="250" SelectedIndex="0">
                                    <telerikInput:RadComboBox.ItemTemplate>
                                        <DataTemplate>
                                            <CheckBox IsChecked="False" Content="{Binding BindsDirectlyToSource=True}" ></CheckBox>
                                        </DataTemplate>
                                    </telerikInput:RadComboBox.ItemTemplate>
                                </telerikInput:RadComboBox>
                                -->

                                     
                                <telerikInput:RadComboBox Name="radRegion2ComboBox" Width="327" EmptyText=" Select one or more Regions "  Margin="60,0,0,0" Height="24" Background="White" BorderBrush="White" OpacityMask="#E8000800" Foreground="#AF000001" IsHighlighted="False" IsHitTestVisible="True">

                                    <telerikInput:RadComboBox.ItemTemplate>

                                            <DataTemplate x:Name="Rad_Region_2_Combo_Box_Data_Template">

                                                <CheckBox ClickMode="Press" Content="{Binding BindsDirectlyToSource=True}" IsChecked="False" Checked="RegionCheckBox_Checked" Unchecked="RegionCheckBox_UnChecked" x:Name="Rad_Region_2_Combo_Box_Check_Box">
                                               
                                            </CheckBox>

                                        </DataTemplate>

                                    </telerikInput:RadComboBox.ItemTemplate>

                                </telerikInput:RadComboBox>
                                   
                                    <TextBlock Height="23" Name="AccountTextBlock" Text="Account" FontWeight="Bold" Width="72" Margin="20,0,0,0" FontStyle="Normal" TextAlignment="Center" FontSize="12" VerticalAlignment="Stretch" HorizontalAlignment="Stretch"><TextBlock.OpacityMask><LinearGradientBrush EndPoint="1,0.5" StartPoint="0,0.5"><GradientStop Color="Black" Offset="0" /><GradientStop Color="SkyBlue" Offset="1" /></LinearGradientBrush></TextBlock.OpacityMask></TextBlock>
                                    <sdk:AutoCompleteBox x:Name="AccountAutoCompleteBox" IsTextCompletionEnabled="True" Width="208" Margin="20,0,0,0" ValueMemberBinding="{Binding}" />
                                    <TextBlock Height="23" Name="BDOwnerTextBlock" Text="BD Owner" FontWeight="Bold" Width="72" Margin="20,0,0,0" TextAlignment="Center" FontSize="12" />
                                    <sdk:AutoCompleteBox x:Name="BDOwnerAutoCompleteBox" IsTextCompletionEnabled="True" Width="170" Margin="20,0,0,0" MaxWidth="200" MaxHeight="25" MinWidth="30" FlowDirection="LeftToRight" HorizontalContentAlignment="Left" VerticalContentAlignment="Top" />

                                  
                                                  
                                    <Button Content="Show Data"  HorizontalAlignment="Left" Name="ShowDataButton" VerticalAlignment="Top" Click="ShowDataButton_Click" Margin="5,0,0,0" />
                                    <Button Content="Submit"  HorizontalAlignment="Left" Name="SaveButton" VerticalAlignment="Top" Click="btn_Save" Margin="5,0,0,0" />
                                   
                                    <!--
                                    <Button Content="Revenue Totals"  HorizontalAlignment="Left" Name="RevTotalButton" VerticalAlignment="Top" Click="RevTotalButton_Click" Margin="5,0,0,0" />
                                    <Button Content="Hide Columns" HorizontalAlignment="Left" Name="HideColumns" VerticalAlignment="Top" Click="ShowHideColumnsOptions" Margin="5,0,0,0"  />
                                    <Button Content="Export" HorizontalAlignment="Left" Name="Export" VerticalAlignment="Top" Click="ExportToExcel" Margin="5,0,0,0"  />
                                    -->
                                   
                                    <Button Content="Show Revenue in USD" HorizontalAlignment="Left" Name="DisplayRevenueInUSDAndLCY" VerticalAlignment="Top" Click="DisplayRevenueInUSDAndLCY_Click" Margin="5,0,0,0"  />

                            </StackPanel>
                        
                       </StackPanel>
                           
                    </telerik:RadWrapPanel>
               
                  </telerik:RadExpander.Content>
                  
             </telerik:RadExpander>

            </StackPanel>

            <grid:RadGridView Name="radGridView" ShowColumnFooters="True" AutoGenerateColumns="False" 
                                  AlternateRowBackground="Coral" Margin="0,110,328,0" HorizontalGridLinesBrush="Black" VerticalGridLinesBrush="Black" BorderBrush="Black" FontWeight="Bold"
                                  FontFamily="Arial" FontSize="11" VerticalAlignment="Top" HorizontalAlignment="Stretch" MaxColumnWidth="500" 
                                  DataLoadMode="Asynchronous" Height="620" RowHeight="15" ScrollMode="RealTime" Width="12700" GroupRowStyle="{StaticResource MyCustomGroupRowStyle}">

                  
                    <i:Interaction.Behaviors>
                   
                    <local:ColumnGroupsBehavior>
                       
                        <local:ColumnGroupsBehavior.CommonHeaders>
                            <local:CommonHeader StartColumnIndex="0" Caption="Opportunity Details" ColumnSpan="30"/>
                            <local:CommonHeader StartColumnIndex="27" Caption="FY UNWEIGHTED REVENUE" ColumnSpan="17" />
                            <local:CommonHeader StartColumnIndex="44" Caption="(FY+1) UNWEIGHTED REVENUE" ColumnSpan="17" />
                            <local:CommonHeader StartColumnIndex="62" Caption="(FY) WEIGHTED REVENUE" ColumnSpan="17" />
                            <local:CommonHeader StartColumnIndex="80" Caption="(FY+1) WEIGHTED REVENUE" ColumnSpan="17" />
                           
                        </local:ColumnGroupsBehavior.CommonHeaders>
                   
                    </local:ColumnGroupsBehavior>
                   
                </i:Interaction.Behaviors>

                   

                 
                   
                    <grid:RadGridView.Columns>

                   
                   <!--
                    <grid:GridViewBoundColumnBase Header="Submit">
                        <grid:GridViewBoundColumnBase.CellTemplate>
                            <DataTemplate>
                                <Button x:Name="UpdateRow" Height="20" Width="40" Content="Submit" Click="UpdateRow_Click" />
                            </DataTemplate>
                        </grid:GridViewBoundColumnBase.CellTemplate>

                    </grid:GridViewBoundColumnBase>
                    -->

                    <grid:GridViewDynamicHyperlinkColumn  Header="Opportunity Name" DataMemberBinding="{Binding OpportunityName}"
                               
                                                         NavigateUrlMemberPaths="OpportunityGUID"

                                                         NavigateUrlFormatString=" "
                                                         
                                                         TargetName="_blank" IsReadOnly="True" UniqueName="OpportunityName" Background="White" HeaderTextAlignment="Center" DisplayIndex="0" x:Name="OpportunityName">

                    </grid:GridViewDynamicHyperlinkColumn>

                        <grid:GridViewDataColumn Header="ID" DataMemberBinding="{Binding OpportunityID}" Width="100" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="1"></grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="Owned By" DataMemberBinding="{Binding Region}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="2"></grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="Duration" DataMemberBinding="{Binding Duration}" IsReadOnly="True" Width="75" HeaderTextAlignment="Center" TextAlignment="Center" DisplayIndex="3"></grid:GridViewDataColumn>

                        <grid:GridViewDynamicHyperlinkColumn  Header="Account" DataMemberBinding="{Binding Account}"
                               
                                                          NavigateUrlMemberPaths="AccountGUID"
                                                         
                                                          NavigateUrlFormatString=" "
                                                         
                                                          TargetName="_blank" IsReadOnly="True" Width="200" HeaderTextAlignment="Center" Background="White" x:Name="Account" DisplayIndex="4"/>

                        <grid:GridViewDataColumn Header="Industry" DataMemberBinding="{Binding Industry}" IsReadOnly="True" Width="150" HeaderTextAlignment="Center" DisplayIndex="5">
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="Operating Unit" DataMemberBinding="{Binding OpUnitClientGroup}" IsReadOnly="True" Width="150" HeaderTextAlignment="Center" DisplayIndex="6">
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="GDN Person Days" DataMemberBinding="{Binding GDNPersonDays}" IsReadOnly="True" Width="95" HeaderTextAlignment="Center" TextAlignment="Center" DisplayIndex="7">
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="Created On" DataMemberBinding="{Binding CreatedOn}" IsReadOnly="True" DataFormatString="{} {0:dd-MMM-yyyy}" UniqueName="CreatedOn" HeaderTextAlignment="Center" TextAlignment="Center" DisplayIndex="8" Width="95">
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="Parent Opportunity ID" DataMemberBinding="{Binding ParentOpportunityID}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="9" Width="75">
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="Probability" DataMemberBinding="{Binding Probability}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="10" Width="75">
                           
                        </grid:GridViewDataColumn>
                       
                        <grid:GridViewDataColumn Header="Sales Stage" DataMemberBinding="{Binding SalesStage}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="11" Width="100">
                           
                        </grid:GridViewDataColumn>
                       
                        <grid:GridViewDataColumn Header="Margin %" DataMemberBinding="{Binding MarginPercent}" IsReadOnly="True" TextAlignment="Center" HeaderTextAlignment="Center" DisplayIndex="12">
                           
                        </grid:GridViewDataColumn>
                       
                         <grid:GridViewDataColumn Header="Effort Days" DataMemberBinding="{Binding EffortDays}" IsReadOnly="False" HeaderTextAlignment="Center" UniqueName="EffortDays" DisplayIndex="13">
                            
                         </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="Est Proj Start Date" DataMemberBinding="{Binding EstimatedProjStDt}" IsReadOnly="True" DataFormatString="{} {0:dd-MMM-yyyy}" UniqueName="EstimatedProjStDt" HeaderTextAlignment="Center" DisplayIndex="14" TextAlignment="Center"></grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="OffShore/Nearshore" DataMemberBinding="{Binding OffShoreLocationName}" IsReadOnly="True" UniqueName="OffShoreLocationName" HeaderTextAlignment="Center" DisplayIndex="15"></grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="Transaction Currency" DataMemberBinding="{Binding TransactionCurrency}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="16" Width="70"></grid:GridViewDataColumn>
                   
                        <grid:GridViewDataColumn Header="Share" DataMemberBinding="{Binding DoNotShareFlag}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="17"></grid:GridViewDataColumn>
                   
                        <grid:GridViewDataColumn Header="SAP Contract ID" DataMemberBinding="{Binding SAPContractID}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="18"></grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="Contract Number" DataMemberBinding="{Binding ContractNumber}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="19"></grid:GridViewDataColumn>
                       
                        <grid:GridViewDataColumn Header="Deal Type" DataMemberBinding="{Binding DealTypeName}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="20"></grid:GridViewDataColumn>
                       
                        <grid:GridViewDataColumn Header="Customer Segment" DataMemberBinding="{Binding CustomerSegment}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="21"></grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="Revenue Type" DataMemberBinding="{Binding REVENUE_TYPE}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="22"></grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="Prime Contracting Party" DataMemberBinding="{Binding PrimeContractingParty}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="23"></grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="Solution" DataMemberBinding="{Binding Solution}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="24"></grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="BD Owner" DataMemberBinding="{Binding BDOwner}" IsReadOnly="True" HeaderTextAlignment="Center" DisplayIndex="25"></grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="Sales Revenue" DataMemberBinding="{Binding SALES_REVENUE}" IsReadOnly="False" HeaderTextAlignment="Center" UniqueName="SALES_REVENUE" DisplayIndex="26">

                           
                            <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="SALES_REVENUE" ResultFormatString="{}{0:N}"/>

                             </grid:GridViewDataColumn.AggregateFunctions>

                         </grid:GridViewDataColumn>
                    

                    <grid:GridViewDataColumn Header="Yield Revenue" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter}, ConverterParameter=YIELD_REVENUE}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="YIELD_REVENUE" DisplayIndex="27">

                            <grid:GridViewDataColumn.Footer >
                               
                                <StackPanel x:Name="YieldRevenue_StackPanel">

                                    <TextBlock x:Name="YIELD_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY" />
                                                                  
                                </StackPanel>
                               
                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                 
                     <grid:GridViewDataColumn DataMemberBinding="{Binding FY_September}" IsReadOnly="False" UniqueName="FY_September" HeaderTextAlignment="Center" DisplayIndex="28">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_September" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn DataMemberBinding="{Binding FY_October}" IsReadOnly="False" UniqueName="FY_October" HeaderTextAlignment="Center" DisplayIndex="29">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_October" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                   
                        <grid:GridViewDataColumn DataMemberBinding="{Binding FY_November}" IsReadOnly="False" UniqueName="FY_November" HeaderTextAlignment="Center" DisplayIndex="30">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_November" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                    

                    <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Q1'}" HeaderTextAlignment="Center" UniqueName="FY_Q1" DisplayIndex="31">

                            <grid:GridViewDataColumn.Footer >

                                <StackPanel x:Name="FYQ1RevenueStackPanel">

                                    <TextBlock x:Name="FYQ1_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                   
                        <grid:GridViewDataColumn DataMemberBinding="{Binding FY_December}" IsReadOnly="False" UniqueName="FY_December" HeaderTextAlignment="Center" DisplayIndex="32">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_December" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                     <grid:GridViewDataColumn DataMemberBinding="{Binding FY_January}" IsReadOnly="False" UniqueName="FY_January" HeaderTextAlignment="Center" DisplayIndex="33">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_January" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn DataMemberBinding="{Binding FY_February}" IsReadOnly="False" UniqueName="FY_February" HeaderTextAlignment="Center" DisplayIndex="34">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_February" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                    <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Q2'}" HeaderTextAlignment="Center" UniqueName="FY_Q2" DisplayIndex="35">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FYQ2RevenueStackPanel">

                                    <TextBlock x:Name="FYQ2_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn DataMemberBinding="{Binding FY_March}" IsReadOnly="False" UniqueName="FY_March" HeaderTextAlignment="Center" DisplayIndex="36">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_March" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                       
                        <grid:GridViewDataColumn DataMemberBinding="{Binding FY_April}" IsReadOnly="False" UniqueName="FY_April" HeaderTextAlignment="Center" DisplayIndex="37">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_April" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                  

                        <grid:GridViewDataColumn DataMemberBinding="{Binding FY_May}" IsReadOnly="False" UniqueName="FY_May" HeaderTextAlignment="Center" DisplayIndex="38">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_May" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Q3'}" HeaderTextAlignment="Center" UniqueName="FY_Q3" DisplayIndex="39">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FYQ3RevenueStackPanel">

                                    <TextBlock x:Name="FYQ3_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                   <grid:GridViewDataColumn DataMemberBinding="{Binding FY_June}" IsReadOnly="False" UniqueName="FY_June" HeaderTextAlignment="Center" DisplayIndex="40">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_June" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn DataMemberBinding="{Binding FY_July}" IsReadOnly="False" UniqueName="FY_July" HeaderTextAlignment="Center" DisplayIndex="41">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_July" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn DataMemberBinding="{Binding FY_August}" IsReadOnly="False" UniqueName="FY_August" HeaderTextAlignment="Center" DisplayIndex="42">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_August" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

 

 

                        <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Q4'}" UniqueName="FY_Q4" HeaderTextAlignment="Center" DisplayIndex="43">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FYQ4RevenueStackPanel">

                                    <TextBlock x:Name="FYQ4_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Total'}" HeaderTextAlignment="Center" UniqueName="FY_Total" DisplayIndex="44">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_Total_Revenue_StackPanel">

                                    <TextBlock x:Name="FYTotal_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                     <grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_September}" IsReadOnly="False" UniqueName="FY_1_September" HeaderTextAlignment="Center" DisplayIndex="45">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_1_September" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                   
                        <grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_October}" IsReadOnly="False" UniqueName="FY_1_October" HeaderTextAlignment="Center" DisplayIndex="46">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_1_October" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_November}" IsReadOnly="False" UniqueName="FY_1_November" HeaderTextAlignment="Center" DisplayIndex="47">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_1_November" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

 

                    <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Q1'}" UniqueName="FY_1_Q1" HeaderTextAlignment="Center" DisplayIndex="48">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_Q1RevenueStackPanel">

                                    <TextBlock x:Name="FY_1_Q1_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                   
                   <grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_December}" IsReadOnly="False" UniqueName="FY_1_December" HeaderTextAlignment="Center" DisplayIndex="49">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_1_December" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                     <grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_January}" IsReadOnly="False" UniqueName="FY_1_January" HeaderTextAlignment="Center" DisplayIndex="50">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_1_January" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                     <grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_February}" IsReadOnly="False" UniqueName="FY_1_February" HeaderTextAlignment="Center" DisplayIndex="51">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_1_February" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                   
                    <grid:GridViewDataColumn  IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Q2'}" HeaderTextAlignment="Center" UniqueName="FY_1_Q2" DisplayIndex="52">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_Q2RevenueStackPanel">

                                    <TextBlock x:Name="FY_1_Q2_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                    <grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_March}" IsReadOnly="False" UniqueName="FY_1_March" HeaderTextAlignment="Center" DisplayIndex="53">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_1_March" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                   

                        <grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_April}" IsReadOnly="False" UniqueName="FY_1_April" HeaderTextAlignment="Center" DisplayIndex="54">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_1_April" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_May}" IsReadOnly="False" UniqueName="FY_1_May" HeaderTextAlignment="Center" DisplayIndex="55">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_1_May" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                    <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Q3'}" HeaderTextAlignment="Center" UniqueName="FY_1_Q3" DisplayIndex="56">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_Q3RevenueStackPanel">

                                    <TextBlock x:Name="FY_1_Q3_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                  
                     <grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_June}" IsReadOnly="False" UniqueName="FY_1_June" HeaderTextAlignment="Center" DisplayIndex="57">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_1_June" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                   
                        <grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_July}" IsReadOnly="False" UniqueName="FY_1_July" HeaderTextAlignment="Center" DisplayIndex="58">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_1_July" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn DataMemberBinding="{Binding FY_1_August}" IsReadOnly="False" UniqueName="FY_1_August" HeaderTextAlignment="Center" DisplayIndex="59">

                        <grid:GridViewDataColumn.AggregateFunctions>

                                <data:SumFunction Caption="Sum (In LCY): "  SourceField="FY_1_August" ResultFormatString="{}{0:N}"/>

                        </grid:GridViewDataColumn.AggregateFunctions>

                    </grid:GridViewDataColumn>

                   
                    <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Q4'}" HeaderTextAlignment="Center" UniqueName="FY_1_Q4" DisplayIndex="60">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_Q4RevenueStackPanel">

                                    <TextBlock x:Name="FY_1_Q4_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                       
                       
                    </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Total'}" HeaderTextAlignment="Center" UniqueName="FY_1_Total" DisplayIndex="61">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_TotalRevenueStackPanel">

                                    <TextBlock x:Name="FY_1_Total_REVENUE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn  DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_September'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_September" DisplayIndex="62" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_SeptemberStackPanel">

                                    <TextBlock x:Name="W_FY_September_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_October'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_October" DisplayIndex="63" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_OctoberStackPanel">

                                    <TextBlock x:Name="W_FY_October_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn  DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_November'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_November" DisplayIndex="64" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_NovemberStackPanel">

                                    <TextBlock x:Name="W_FY_November_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Q1'}" HeaderTextAlignment="Center" UniqueName="W_FY_Q1" DisplayIndex="65" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_Q1_StackPanel">

                                    <TextBlock x:Name="W_FY_Q1_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_December'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_December" DisplayIndex="66" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_December_StackPanel">

                                    <TextBlock x:Name="W_FY_December_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                    </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn  DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_January'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_January" DisplayIndex="67" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_January_StackPanel">

                                    <TextBlock x:Name="W_FY_January_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           
                    </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn  DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_February'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_February" DisplayIndex="68" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_February_StackPanel">

                                    <TextBlock x:Name="W_FY_February_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Q2'}" HeaderTextAlignment="Center" UniqueName="W_FY_Q2" DisplayIndex="69" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_Q2StackPanel">

                                    <TextBlock x:Name="W_FY_Q2_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

 

 

                     <grid:GridViewDataColumn  DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_March'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_March" DisplayIndex="70" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_MarchStackPanel">

                                    <TextBlock x:Name="W_FY_March_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

 

                    <grid:GridViewDataColumn  DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_April'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_April" DisplayIndex="71" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_AprilStackPanel">

                                    <TextBlock x:Name="W_FY_April_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                    <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_May'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_May" DisplayIndex="72" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_MayStackPanel">

                                    <TextBlock x:Name="W_FY_May_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                    <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Q3'}" HeaderTextAlignment="Center" UniqueName="W_FY_Q3" DisplayIndex="73" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_Q3StackPanel">

                                    <TextBlock x:Name="W_FY_Q3_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                    <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_June'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_June" DisplayIndex="74" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_JuneStackPanel">

                                    <TextBlock x:Name="W_FY_June_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_July'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_July" DisplayIndex="75" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_JulyStackPanel">

                                    <TextBlock x:Name="W_FY_July_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_August'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_August" DisplayIndex="76" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_AugustStackPanel">

                                    <TextBlock x:Name="W_FY_August_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Q4'}" HeaderTextAlignment="Center" UniqueName="W_FY_Q4" DisplayIndex="77" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_Q4StackPanel">

                                    <TextBlock x:Name="W_FY_Q4_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Total'}" HeaderTextAlignment="Center" UniqueName="W_FY_Total" DisplayIndex="78" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_TotalStackPanel">

                                    <TextBlock x:Name="W_FY_Total_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                    </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_September'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_September" DisplayIndex="79" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_SeptemberStackPanel">

                                    <TextBlock x:Name="W_FY_1_September_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                    </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_October'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_October" DisplayIndex="80" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_OctoberStackPanel">

                                    <TextBlock x:Name="W_FY_1_October_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_November'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_November" DisplayIndex="81" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_NovemberStackPanel">

                                    <TextBlock x:Name="W_FY_1_November_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           

                    </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Q1'}" HeaderTextAlignment="Center" UniqueName="W_FY_1_Q1" DisplayIndex="82" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_Q1StackPanel">

                                    <TextBlock x:Name="W_FY_1_Q1_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           

                    </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_December'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_December" DisplayIndex="83" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_DecemberStackPanel">

                                    <TextBlock x:Name="W_FY_1_December_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_January'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_January" DisplayIndex="84" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_JanuaryStackPanel">

                                    <TextBlock x:Name="W_FY_1_January_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_February'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_February" DisplayIndex="85" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_FebruaryStackPanel">

                                    <TextBlock x:Name="W_FY_1_February_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn  IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Q2'}" HeaderTextAlignment="Center" UniqueName="W_FY_1_Q2" DisplayIndex="86" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_Q2StackPanel">

                                    <TextBlock x:Name="W_FY_1_Q2_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_March'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_March" DisplayIndex="87" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_MarchStackPanel">

                                    <TextBlock x:Name="W_FY_1_March_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                     <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_April'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_April" DisplayIndex="88" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_AprilStackPanel">

                                    <TextBlock x:Name="W_FY_1_April_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_May'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_May" DisplayIndex="89" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_MayStackPanel">

                                    <TextBlock x:Name="W_FY_1_May_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Q3'}" HeaderTextAlignment="Center" UniqueName="W_FY_1_Q3" DisplayIndex="90" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_Q3StackPanel">

                                    <TextBlock x:Name="W_FY_1_Q3_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_June'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_June" DisplayIndex="91" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_JuneStackPanel">

                                    <TextBlock x:Name="W_FY_1_June_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                    </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn  DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_July'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_July" DisplayIndex="92" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_JulyStackPanel">

                                    <TextBlock x:Name="W_FY_1_July_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_August'}" IsReadOnly="True" HeaderTextAlignment="Center" UniqueName="W_FY_1_August" DisplayIndex="93" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_AugustStackPanel">

                                    <TextBlock x:Name="W_FY_1_August_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                    </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Q4'}" HeaderTextAlignment="Center" UniqueName="W_FY_1_Q4" DisplayIndex="94" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_Q4StackPanel">

                                    <TextBlock x:Name="W_FY_1_Q4_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                    </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Total'}" HeaderTextAlignment="Center" UniqueName="W_FY_1_Total" DisplayIndex="95" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_TotalStackPanel">

                                    <TextBlock x:Name="W_FY_1_Total_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                
                        <grid:GridViewDataColumn Header="Opportunity GUID" DataMemberBinding="{Binding OpportunityGUID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="Account GUID" DataMemberBinding="{Binding AccountGUID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="Forecast GUID" DataMemberBinding="{Binding ForecastGUID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>

                        <!--
                        <grid:GridViewDataColumn Header="FY September ID" DataMemberBinding="{Binding FY_September_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY October ID"   DataMemberBinding="{Binding FY_October_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY November ID"  DataMemberBinding="{Binding FY_November_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY December ID" DataMemberBinding="{Binding FY_December_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY January ID" DataMemberBinding="{Binding FY_January_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY February ID" DataMemberBinding="{Binding FY_February_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY March ID" DataMemberBinding="{Binding FY_March_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY April ID" DataMemberBinding="{Binding FY_April_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY May ID" DataMemberBinding="{Binding FY_May_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY June ID" DataMemberBinding="{Binding FY_June_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY July ID" DataMemberBinding="{Binding FY_July_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY August ID" DataMemberBinding="{Binding FY_August_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center"></grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="FY 1 September ID" DataMemberBinding="{Binding FY_1_September_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY 1 October ID" DataMemberBinding="{Binding FY_1_October_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY 1 November ID" DataMemberBinding="{Binding FY_1_November_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY 1 December ID" DataMemberBinding="{Binding FY_1_December_ID}" IsReadOnly="True" IsVisible="False" HeaderTextAlignment="Center" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY 1 January ID" DataMemberBinding="{Binding FY_1_January_ID}" IsReadOnly="True" IsVisible="False" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY 1 February ID" DataMemberBinding="{Binding FY_1_February_ID}" IsReadOnly="True" IsVisible="False" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY 1 March ID" DataMemberBinding="{Binding FY_1_March_ID}" IsReadOnly="True" IsVisible="False" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY 1 April ID" DataMemberBinding="{Binding FY_1_April_ID}" IsReadOnly="True" IsVisible="False" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY 1 May ID" DataMemberBinding="{Binding FY_1_May_ID}" IsReadOnly="True" IsVisible="False" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY 1 June ID" DataMemberBinding="{Binding FY_1_June_ID}" IsReadOnly="True" IsVisible="False" ></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY 1 July ID" DataMemberBinding="{Binding FY_1_July_ID}" IsReadOnly="True" IsVisible="False"></grid:GridViewDataColumn>
                        <grid:GridViewDataColumn Header="FY 1 August ID" DataMemberBinding="{Binding FY_1_August_ID}" IsReadOnly="True" IsVisible="False"></grid:GridViewDataColumn>
                        -->

                        <grid:GridViewDataColumn Header="Sales Revenue (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='SALES_REVENUE_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="SALES_REVENUE_BASE" DisplayIndex="96">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="SALES_REVENUE_BASE_StackPanel">

                                    <TextBlock x:Name="SALES_REVENUE_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="Yield Revenue (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='YIELD_REVENUE_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="YIELD_REVENUE_BASE" DisplayIndex="97">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="YIELD_REVENUE_BASE_StackPanel">

                                    <TextBlock x:Name="YIELD_REVENUE_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="FY September (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_September_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_September_BASE" DisplayIndex="98">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_September_BASE_StackPanel">

                                    <TextBlock x:Name="FY_September_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="FY October (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_October_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_October_BASE" DisplayIndex="99">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_October_BASE_StackPanel">

                                    <TextBlock x:Name="FY_October_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="FY November (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_November_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_November_BASE" DisplayIndex="100">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_November_BASE_StackPanel">

                                    <TextBlock x:Name="FY_November_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="FY Q1 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Q1_BASE'}" IsVisible="False" HeaderTextAlignment="Center" UniqueName="FY_Q1_BASE" DisplayIndex="101">

 

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_Q1_BASE_StackPanel">

                                    <TextBlock x:Name="FY_Q1_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="FY December (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_December_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_December_BASE" DisplayIndex="102">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_December_BASE_StackPanel">

                                    <TextBlock x:Name="FY_December_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="FY January (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_January_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_January_BASE" DisplayIndex="103">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_January_BASEStackPanel">

                                    <TextBlock x:Name="FY_January_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="FY February (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_February_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_February_BASE" DisplayIndex="104">
                           
                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_February_BASEStackPanel">

                                    <TextBlock x:Name="FY_February_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="FY Q2 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Q2_BASE'}" IsVisible="False" HeaderTextAlignment="Center" UniqueName="FY_Q2_BASE" DisplayIndex="105">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_Q2_BASEStackPanel">

                                    <TextBlock x:Name="FY_Q2_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           
                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn Header="FY March (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_March_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_March_BASE" DisplayIndex="106">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_March_BASEStackPanel">

                                    <TextBlock x:Name="FY_March_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn Header="FY April (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_April_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_April_BASE" DisplayIndex="107">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_April_BASEStackPanel">

                                    <TextBlock x:Name="FY_April_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn Header="FY May (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_May_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_May_BASE" DisplayIndex="108">

                           <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_May_BASEStackPanel">

                                    <TextBlock x:Name="FY_May_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                       
                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn Header="FY Q3 (USD)"  IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Q3_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="FY_Q3_BASE" DisplayIndex="109">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_Q3_BASEStackPanel">

                                    <TextBlock x:Name="FY_Q3_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           
                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn Header="FY June (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_June_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_June_BASE" DisplayIndex="110">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_June_BASEStackPanel">

                                    <TextBlock x:Name="FY_June_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="FY July (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_July_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_July_BASE" DisplayIndex="111">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_July_BASEStackPanel">

                                    <TextBlock x:Name="FY_July_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn Header="FY August (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_August_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_August_BASE" DisplayIndex="112">

                         <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_August_BASEStackPanel">

                                    <TextBlock x:Name="FY_August_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           
                           
                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn Header="FY Q4 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Q4_BASE'}" UniqueName="FY_Q4_BASE" IsVisible="False" HeaderTextAlignment="Center" DisplayIndex="113">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_Q4_BASEStackPanel">

                                    <TextBlock x:Name="FY_Q4_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="FY Total (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_Total_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="FY_Total_BASE" DisplayIndex="114">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_Total_BASEStackPanel">

                                    <TextBlock x:Name="FY_Total_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="(FY+1) September (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_September_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_September_BASE" DisplayIndex="115">

                             <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_September_BASEStackPanel">

                                    <TextBlock x:Name="FY_1_September_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn Header="(FY+1) October (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_October_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_October_BASE" DisplayIndex="116">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_October_BASEStackPanel">

                                    <TextBlock x:Name="FY_1_October_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           

                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn Header="(FY+1) November (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_November_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_November_BASE" DisplayIndex="117">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_November_BASEStackPanel">

                                    <TextBlock x:Name="FY_1_November_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           
                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn Header="(FY+1) Q1 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Q1_BASE'}" UniqueName="FY_1_Q1_BASE" IsVisible="False" HeaderTextAlignment="Center" DisplayIndex="118">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_Q1_BASEStackPanel">

                                    <TextBlock x:Name="FY_1_Q1_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           

                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn Header="(FY+1) December (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_December_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_December_BASE" DisplayIndex="119">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_December_BASEStackPanel">

                                    <TextBlock x:Name="FY_1_December_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           

                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn Header="(FY+1) January (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_January_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_January_BASE" DisplayIndex="120">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_January_BASEStackPanel">

                                    <TextBlock x:Name="FY_1_January_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

 

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="(FY+1) February (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_February_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_February_BASE" DisplayIndex="121">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_February_BASEStackPanel">

                                    <TextBlock x:Name="FY_1_February_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn Header="(FY+1) Q2 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Q2_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="FY_1_Q2_BASE" DisplayIndex="122">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_Q2_BASEStackPanel">

                                    <TextBlock x:Name="FY_1_Q2_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="(FY+1) March (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_March_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_March_BASE" DisplayIndex="123">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_March_BASEStackPanel">

                                    <TextBlock x:Name="FY_1_March_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                                                     
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="(FY+1) April (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_April_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_April_BASE" DisplayIndex="124">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_April_BASEStackPanel">

                                    <TextBlock x:Name="FY_1_April_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="(FY+1) May (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_May_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_May_BASE" DisplayIndex="125">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_May_BASEStackPanel">

                                    <TextBlock x:Name="FY_1_May_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="(FY+1) Q3 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Q3_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="FY_1_Q3_BASE" DisplayIndex="126">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_Q3_BASEStackPanel">

                                    <TextBlock x:Name="FY_1_Q3_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           
                        </grid:GridViewDataColumn>

 

                        <grid:GridViewDataColumn Header="(FY+1) June (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_June_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_June_BASE" DisplayIndex="127">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_June_BASEStackPanel">

                                    <TextBlock x:Name="FY_1_June_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="(FY+1) July (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_July_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_July_BASE" DisplayIndex="128">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_July_BASE_StackPanel">

                                    <TextBlock x:Name="FY_1_July_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

 

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="(FY+1) August (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_August_BASE'}" IsReadOnly="True" IsVisible="False" UniqueName="FY_1_August_BASE" DisplayIndex="129">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_August_BASE_StackPanel">

                                    <TextBlock x:Name="FY_1_August_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="(FY+1) Q4 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Q4_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="FY_1_Q4_BASE" DisplayIndex="130">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_Q4_BASEStackPanel">

                                    <TextBlock x:Name="FY_1_Q4_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

 

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="(FY+1) Total (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='FY_1_Total_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="FY_1_Total_BASE" DisplayIndex="131">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="FY_1_Total_BASEStackPanel">

                                    <TextBlock x:Name="FY_1_Total_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-SEP (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_September_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_September_BASE" DisplayIndex="132" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_September_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_September_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-OCT (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_October_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_October_BASE" DisplayIndex="133" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_October_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_October_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-NOV (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_November_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_November_BASE" DisplayIndex="134" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_November_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_November_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-Q1 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Q1_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_Q1_BASE" DisplayIndex="135" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_Q1_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_Q1_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-DEC (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_December_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_December_BASE" DisplayIndex="136" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_December_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_December_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-JAN (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_January_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_January_BASE" DisplayIndex="137" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_January_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_January_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                                                     
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-FEB (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_February_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_February_BASE" DisplayIndex="138" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_February_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_February_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-Q2 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Q2_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_Q2_BASE" DisplayIndex="139" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_Q2_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_Q2_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-MAR (USD)"  DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_March_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False"  UniqueName="W_FY_March_BASE" DisplayIndex="140" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_March_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_March_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-APR (USD)"  DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_April_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_April_BASE" DisplayIndex="141" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_April_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_April_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-MAY (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_May_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_May_BASE" DisplayIndex="142" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_May_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_May_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-Q3 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Q3_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_Q3_BASE" DisplayIndex="143" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_Q3_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_Q3_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-JUNE (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_June_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_June_BASE" DisplayIndex="144" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_June_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_June_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-JULY (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_July_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_July_BASE" DisplayIndex="145" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

 

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_July_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_July_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-AUG (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_August_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_August_BASE" DisplayIndex="146" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

 

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_August_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_August_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-Q4 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Q4_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_Q4_BASE" DisplayIndex="147" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_Q4_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_Q4_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED FY-Total (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_Total_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_Total_BASE" DisplayIndex="148" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_Total_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_Total_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                         
                        </grid:GridViewDataColumn>
                   
                   

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-SEP (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_September_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_September_BASE" DisplayIndex="149" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_September_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_September_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-OCT (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_October_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_October_BASE" DisplayIndex="150" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_October_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_October_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-NOV (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_November_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_November_BASE" DisplayIndex="151" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_November_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_November_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-Q1 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Q1_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_Q1_BASE" DisplayIndex="152" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_Q1_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_Q1_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-DEC (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_December_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_December_BASE" DisplayIndex="153" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

 

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_December_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_December_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-JAN (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_January_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_January_BASE" DisplayIndex="154" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

 

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_January_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_January_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-FEB (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_February_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_February_BASE" DisplayIndex="155" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_February_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_February_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-Q2 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Q2_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_Q2_BASE" DisplayIndex="156" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_Q2_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_Q2_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-MAR (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_March_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_March_BASE" DisplayIndex="157" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_March_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_March_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-APR (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_April_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_April_BASE" DisplayIndex="158" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_April_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_April_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                                                     
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-MAY (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_May_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_May_BASE" DisplayIndex="159" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_May_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_May_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-Q3 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Q3_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_Q3_BASE" DisplayIndex="160" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_Q3_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_Q3_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-JUNE (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_June_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_June_BASE" DisplayIndex="161" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_June_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_June_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-JULY (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_July_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_July_BASE" DisplayIndex="162" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_July_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_July_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-AUG (USD)" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_August_BASE'}" IsReadOnly="True" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_August_BASE" DisplayIndex="163" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_August_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_August_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-Q4 (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Q4_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_Q4_BASE" DisplayIndex="164" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_Q4_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_Q4_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>
                           
                        </grid:GridViewDataColumn>

                        <grid:GridViewDataColumn Header="WEIGHTED (FY+1)-Total (USD)" IsReadOnly="True" DataMemberBinding="{Binding Converter={StaticResource CalculatingConverter},ConverterParameter='W_FY_1_Total_BASE'}" HeaderTextAlignment="Center" IsVisible="False" UniqueName="W_FY_1_Total_BASE" DisplayIndex="165" Background="LightBlue" HeaderCellStyle="{StaticResource MyHeaderCellStyle}">

                            <grid:GridViewDataColumn.Footer>

                                <StackPanel x:Name="W_FY_1_Total_BASE_StackPanel">

                                    <TextBlock x:Name="W_FY_1_Total_BASE_TOTAL_FOOTER_TXTBLOCK_LCY"/>

                                </StackPanel>

                            </grid:GridViewDataColumn.Footer>

                        </grid:GridViewDataColumn>

                    </grid:RadGridView.Columns>
               
            </grid:RadGridView>
               
               
           
        
         <!--      
            <ListBox ItemsSource="{Binding Columns, ElementName=radGridView}" Width="220" HorizontalAlignment="Left" Margin="-2,82,0,34">
               
                <ListBox.ItemTemplate>
                    <DataTemplate>
                        <CheckBox Content="{Binding Header}" IsChecked="{Binding IsVisible, Mode=TwoWay}" />
                    </DataTemplate>
                </ListBox.ItemTemplate>
           
            </ListBox>
          
            <ScrollBar Height="607" HorizontalAlignment="Left" Margin="243,82,0,0" Name="scrollBar2" VerticalAlignment="Top" Width="17" ValueChanged="scrollBar1_ValueChanged" />
       -->
   
        </Grid>

    </ScrollViewer>

   
</UserControl>

=================================================== XAML PAGE CODE BEHIND================================

using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.IO;
using System.Linq;
using System.Net.NetworkInformation;
using System.ServiceModel;
using System.Threading;
using System.Windows;
using System.Windows.Browser;
using System.Windows.Controls;
using System.Windows.Controls.Primitives;
using System.Windows.Data;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Threading;
using System.Data.Services.Client;
using Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService;
using Telerik.Windows.Controls;
using Telerik.Windows.Controls.GridView;
using Telerik.Windows.Data;
using System.Text.RegularExpressions;

namespace Avanade.Crm.Sam.RPT
{
    [ScriptableType]

    public partial class MainPage : UserControl
    {

        private RevenueProjectionToolServiceClient CommService { get; set; }

        int InitialPageSize = 50;
        int InitialStartingRow = 0;
        int PageSize = 50;
        int StartingRow = 0;
       
        int CurrentYear = System.DateTime.Now.Year;
        int CurrentMonth = System.DateTime.Now.Month;
        int CurrentDay = System.DateTime.Now.Day;

        Stack<GridViewRow> EditedRowData = new Stack<GridViewRow>();

        string[] EditableColumnUniqueNames = { "FY_September","FY_October","FY_November","FY_December","FY_January","FY_February","FY_March","FY_April","FY_May","FY_June","FY_July","FY_August","FY_1_September","FY_1_October","FY_1_November","FY_1_December","FY_1_January","FY_1_February","FY_1_March","FY_1_April","FY_1_May","FY_1_June","FY_1_July","FY_1_August","SALES_REVENUE", "EffortDays"};

        List<string> RegionNames = new List<string>();

        IGroupDescriptor[] IGrpDescArr;

        string SERVER_NAME;

        GetRevenueProjection_Result[] RPTDataArray;
   
        public MainPage()
        {
            InitializeComponent();

            this.CommService = new RevenueProjectionToolServiceClient();

            Loaded += new RoutedEventHandler(Page_Loaded);

            HtmlPage.RegisterScriptableObject("Page", this);
        }

              
        public void Page_Loaded(object sender, RoutedEventArgs e)
       
        {
            try
            {
                RevenueProjectionToolWCFService.RevenueProjectionToolServiceClient ws = new Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.RevenueProjectionToolServiceClient();

                ws.GetRevenueProjectionFilterDataCompleted += new EventHandler<GetRevenueProjectionFilterDataCompletedEventArgs>(ws_GetRevenueProjectionFilterDataCompleted);

                ws.GetRevenueProjectionFilterDataAsync();

                ws.GetSystemInformationCompleted += new EventHandler<GetSystemInformationCompletedEventArgs>(ws_GetSystemInformationCompleted);

                ws.GetSystemInformationAsync();

            }

            catch (Exception Excep)
            {

                MessageBox.Show(Excep.InnerException + Excep.Message + Excep.StackTrace.ToString());
           
            }

        }

        public void ws_GetSystemInformationCompleted(object sender, Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetSystemInformationCompletedEventArgs e)
        {

            SERVER_NAME = e.Result.ToString();    
        }

        public void ws_GetRevenueProjectionFilterDataCompleted(object sender, Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjectionFilterDataCompletedEventArgs e)
        {

            var accquery = (from p in e.Result select p.Account).Distinct();
            this.AccountAutoCompleteBox.ItemsSource = accquery.ToArray();
            this.AccountAutoCompleteBox.PopulateComplete();

             var bdownerquery = (from p in e.Result select p.BDOwner).Distinct();
             this.BDOwnerAutoCompleteBox.ItemsSource = bdownerquery.ToArray();
             this.BDOwnerAutoCompleteBox.PopulateComplete();

             var regionquery = (from p in e.Result select p.Region).Distinct();
             this.radRegion2ComboBox.ItemsSource = regionquery.ToArray();
          
        }
       
      
        public void ws_RevenueProjectionToolDataPageWiseCompleted(object sender, Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjectionToolDataPageWiseCompletedEventArgs e)
        {

            try
            {

                RPTDataArray = new GetRevenueProjection_Result[e.Result.ToArray().Length];

                radGridView.Visibility = Visibility.Visible;

                ToolUtilities.GenerateReportHeaders(radGridView);

                ToolUtilities DataList = new ToolUtilities();
 
                RPTDataArray = DataList.CalculateRevenueSpread(e.Result.ToArray());

                this.radGridView.ItemsSource = RPTDataArray;

                decimal[] CalculatedColumnFooterTotals = CalculatedColumnsFooterTotals.CalculateTotalsForCalculatedColumns(RPTDataArray);
                                 
                System.Windows.Controls.UIElementCollection oyieldRev = ((System.Windows.Controls.Panel)(this.radGridView.Columns["YIELD_REVENUE"].Footer)).Children;
                UIElement[] oyieldRevArr = oyieldRev.ToArray();
                ((System.Windows.Controls.TextBlock)(oyieldRevArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[0],2).ToString();
             
                System.Windows.Controls.UIElementCollection oFYQ1 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_Q1"].Footer)).Children;
                UIElement[] oFYQ1Arr = oFYQ1.ToArray();
                ((System.Windows.Controls.TextBlock)(oFYQ1Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[1], 2).ToString();

                System.Windows.Controls.UIElementCollection oFYQ2 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_Q2"].Footer)).Children;
                UIElement[] oFYQ2Arr = oFYQ2.ToArray();
                ((System.Windows.Controls.TextBlock)(oFYQ2Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[2], 2).ToString();

                System.Windows.Controls.UIElementCollection oFYQ3 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_Q3"].Footer)).Children;
                UIElement[] oFYQ3Arr = oFYQ3.ToArray();
                ((System.Windows.Controls.TextBlock)(oFYQ3Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[3], 2).ToString();

                System.Windows.Controls.UIElementCollection oFYQ4 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_Q4"].Footer)).Children;
                UIElement[] oFYQ4Arr = oFYQ4.ToArray();
                ((System.Windows.Controls.TextBlock)(oFYQ4Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[4], 2).ToString();

                System.Windows.Controls.UIElementCollection oFYTotal = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_Total"].Footer)).Children;
                UIElement[] oFYTotalArr = oFYTotal.ToArray();
                ((System.Windows.Controls.TextBlock)(oFYTotalArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[5], 2).ToString();

                System.Windows.Controls.UIElementCollection oFY_1_Q1 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_1_Q1"].Footer)).Children;
                UIElement[] oFY_1_Q1Arr = oFY_1_Q1.ToArray();
                ((System.Windows.Controls.TextBlock)(oFY_1_Q1Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[6], 2).ToString();

                System.Windows.Controls.UIElementCollection oFY_1_Q2 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_1_Q2"].Footer)).Children;
                UIElement[] oFY_1_Q2Arr = oFY_1_Q2.ToArray();
                ((System.Windows.Controls.TextBlock)(oFY_1_Q2Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[7], 2).ToString();
             
                System.Windows.Controls.UIElementCollection oFY_1_Q3 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_1_Q3"].Footer)).Children;
                UIElement[] oFY_1_Q3Arr = oFY_1_Q3.ToArray();
                ((System.Windows.Controls.TextBlock)(oFY_1_Q3Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[8], 2).ToString();

                System.Windows.Controls.UIElementCollection oFY_1_Q4 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_1_Q4"].Footer)).Children;
                UIElement[] oFY_1_Q4Arr = oFY_1_Q4.ToArray();
                ((System.Windows.Controls.TextBlock)(oFY_1_Q4Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[9], 2).ToString();

                System.Windows.Controls.UIElementCollection oFY_1_Total = ((System.Windows.Controls.Panel)(this.radGridView.Columns["FY_1_Total"].Footer)).Children;
                UIElement[] oFY_1_TotalArr = oFY_1_Total.ToArray();
                ((System.Windows.Controls.TextBlock)(oFY_1_TotalArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[10], 2).ToString();

               
                System.Windows.Controls.UIElementCollection oW_FY_Sep = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_September"].Footer)).Children;
                UIElement[] oW_FY_SepArr = oW_FY_Sep.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_SepArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[11], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_Oct = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_October"].Footer)).Children;
                UIElement[] oW_FY_OctArr = oW_FY_Oct.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_OctArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[12], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_Nov = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_November"].Footer)).Children;
                UIElement[] oW_FY_NovArr = oW_FY_Nov.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_NovArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[13], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_Q1 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_Q1"].Footer)).Children;
                UIElement[] oW_FY_Q1Arr = oW_FY_Q1.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_Q1Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[14], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_Dec = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_December"].Footer)).Children;
                UIElement[] oW_FY_DecArr = oW_FY_Dec.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_DecArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[15], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_Jan = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_January"].Footer)).Children;
                UIElement[] oW_FY_JanArr = oW_FY_Jan.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_JanArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[16], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_Feb = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_February"].Footer)).Children;
                UIElement[] oW_FY_FebArr = oW_FY_Feb.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_FebArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[17], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_Q2 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_Q2"].Footer)).Children;
                UIElement[] oW_FY_Q2Arr = oW_FY_Q2.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_Q2Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[18], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_Mar = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_March"].Footer)).Children;
                UIElement[] oW_FY_MarArr = oW_FY_Mar.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_MarArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[19], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_Apr = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_April"].Footer)).Children;
                UIElement[] oW_FY_AprArr = oW_FY_Apr.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_AprArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[20], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_May = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_May"].Footer)).Children;
                UIElement[] oW_FY_MayArr = oW_FY_May.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_MayArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[21], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_Q3 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_Q3"].Footer)).Children;
                UIElement[] oW_FY_Q3Arr = oW_FY_Q3.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_Q3Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[22], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_June = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_June"].Footer)).Children;
                UIElement[] oW_FY_JuneArr = oW_FY_June.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_JuneArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[23], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_July = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_July"].Footer)).Children;
                UIElement[] oW_FY_JulyArr = oW_FY_July.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_JulyArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[24], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_Aug = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_August"].Footer)).Children;
                UIElement[] oW_FY_AugArr = oW_FY_Aug.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_AugArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[25], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_Q4 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_Q4"].Footer)).Children;
                UIElement[] oW_FY_Q4Arr = oW_FY_Q4.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_Q4Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[26], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_Total = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_Total"].Footer)).Children;
                UIElement[] oW_FY_TotalArr = oW_FY_Total.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_TotalArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[27], 2).ToString();
          
                System.Windows.Controls.UIElementCollection oW_FY_1_Sep = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_September"].Footer)).Children;
                UIElement[] oW_FY_1_SepArr = oW_FY_1_Sep.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_SepArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[28], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_1_Oct = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_October"].Footer)).Children;
                UIElement[] oW_FY_1_OctArr = oW_FY_1_Oct.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_OctArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[29], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_1_Nov = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_November"].Footer)).Children;
                UIElement[] oW_FY_1_NovArr = oW_FY_1_Nov.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_NovArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[30], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_1_Q1 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_Q1"].Footer)).Children;
                UIElement[] oW_FY_1_Q1Arr = oW_FY_1_Q1.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_Q1Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[31], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_1_Dec = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_December"].Footer)).Children;
                UIElement[] oW_FY_1_DecArr = oW_FY_1_Dec.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_DecArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[32], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_1_Jan = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_January"].Footer)).Children;
                UIElement[] oW_FY_1_JanArr = oW_FY_1_Jan.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_JanArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[33], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_1_Feb = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_February"].Footer)).Children;
                UIElement[] oW_FY_1_FebArr = oW_FY_1_Feb.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_FebArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[34], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_1_Q2 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_Q2"].Footer)).Children;
                UIElement[] oW_FY_1_Q2Arr = oW_FY_1_Q2.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_Q2Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[35], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_1_Mar = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_March"].Footer)).Children;
                UIElement[] oW_FY_1_MarArr = oW_FY_1_Mar.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_MarArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[36], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_1_Apr = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_April"].Footer)).Children;
                UIElement[] oW_FY_1_AprArr = oW_FY_1_Apr.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_AprArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[37], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_1_May = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_May"].Footer)).Children;
                UIElement[] oW_FY_1_MayArr = oW_FY_1_May.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_MayArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[38], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_1_Q3 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_Q3"].Footer)).Children;
                UIElement[] oW_FY_1_Q3Arr = oW_FY_1_Q3.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_Q3Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[39], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_1_June = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_June"].Footer)).Children;
                UIElement[] oW_FY_1_JuneArr = oW_FY_1_June.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_JuneArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[40], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_1_July = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_July"].Footer)).Children;
                UIElement[] oW_FY_1_JulyArr = oW_FY_1_July.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_JulyArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[41], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_1_Aug = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_August"].Footer)).Children;
                UIElement[] oW_FY_1_AugArr = oW_FY_1_Aug.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_AugArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[42], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_1_Q4 = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_Q4"].Footer)).Children;
                UIElement[] oW_FY_1_Q4Arr = oW_FY_1_Q4.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_Q4Arr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[43], 2).ToString();

                System.Windows.Controls.UIElementCollection oW_FY_1_Total = ((System.Windows.Controls.Panel)(this.radGridView.Columns["W_FY_1_Total"].Footer)).Children;
                UIElement[] oW_FY_1_TotalArr = oW_FY_1_Total.ToArray();
                ((System.Windows.Controls.TextBlock)(oW_FY_1_TotalArr[0])).Text = "Sum (In LCY): " + decimal.Round(CalculatedColumnFooterTotals[44], 2).ToString();
 
                ShowDataButton.IsEnabled = true;
                GroupRevenueBySalesStage GrpBySalesStage = new GroupRevenueBySalesStage();
                GrpBySalesStage.ShowRevenueBySalesStageGroupingLCY(radGridView);
                IGrpDescArr = this.radGridView.GroupDescriptors.ToArray();
              
                //In Dev environments replace SERVER_NAME with SERVER_NAME + ":5555"

                // Need To replace http with https for production
               
                GridViewColumn OppColumn = this.radGridView.Columns["OpportunityName"];

                ((Telerik.Windows.Controls.GridViewDynamicHyperlinkColumn)(OppColumn)).NavigateUrlFormatString = " http://" + SERVER_NAME + "/Avanade/sfa/opps/RBUIedit.aspx?id={0}";

                GridViewColumn AccColumn = this.radGridView.Columns["Account"];

                ((Telerik.Windows.Controls.GridViewDynamicHyperlinkColumn)(AccColumn)).NavigateUrlFormatString = " http://" + SERVER_NAME + "/Avanade/sfa/accts/RBUIedit.aspx?id={0}";

               
                             
            }

            catch (Exception Excep)
            {

                MessageBox.Show(Excep.InnerException.StackTrace.ToString() + Excep.Message.ToString());
           
            }

         
        }

 
        /*
        private void radGridView_RowEditEnded(object sender, GridViewRowEditEndedEventArgs e)
        {
            try
            {
                if (e.EditAction == GridViewEditAction.Cancel)
                {
                    return;
                }

                if (e.EditOperationType == GridViewEditOperationType.Edit)
                {

                    EditedRowData.Push(e.Row);
                }
            }

            catch (Exception Excep)
            {

                MessageBox.Show(Excep.Message.ToString() + " " + Excep.StackTrace.ToString());
           
            }

        }

       
        private void radGridView_CellEditEnded(object sender, GridViewCellEditEndedEventArgs e)
        {

           
            try
            {

                decimal Weighted_FY_Sep = 0, Weighted_FY_Oct = 0, Weighted_FY_Nov = 0, Weighted_FY_Dec = 0, Weighted_FY_Jan = 0, Weighted_FY_Feb = 0, Weighted_FY_Mar = 0, Weighted_FY_April = 0, Weighted_FY_May = 0, Weighted_FY_June = 0, Weighted_FY_July = 0, Weighted_FY_Aug = 0, Weighted_FY_1_Sep = 0, Weighted_FY_1_Oct = 0, Weighted_FY_1_Nov = 0, Weighted_FY_1_Dec = 0, Weighted_FY_1_Jan = 0, Weighted_FY_1_Feb = 0, Weighted_FY_1_Mar = 0, Weighted_FY_1_Apr = 0, Weighted_FY_1_May = 0, Weighted_FY_1_June = 0, Weighted_FY_1_July = 0, Weighted_FY_1_Aug = 0;

                decimal _FY_Sep = 0, _FY_Oct = 0, _FY_Nov = 0, _FY_Dec = 0, _FY_Jan = 0, _FY_Feb = 0, _FY_Mar = 0, _FY_April = 0, _FY_May = 0, _FY_June = 0, _FY_July = 0, _FY_Aug = 0, _FY_1_Sep = 0, _FY_1_Oct = 0, _FY_1_Nov = 0, _FY_1_Dec = 0, _FY_1_Jan = 0, _FY_1_Feb = 0, _FY_1_Mar = 0, _FY_1_Apr = 0, _FY_1_May = 0, _FY_1_June = 0, _FY_1_July = 0, _FY_1_Aug = 0;

                for (int p = 0; p < EditableColumnUniqueNames.Length; p++)
                {

                    if (e.Cell.Column.UniqueName == EditableColumnUniqueNames[p])
                    {

                        e.Cell.Background = new SolidColorBrush(Colors.Green);

                        break;

                    }

                }

                int Probability = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(e.Cell.ParentRow.GridViewDataControl.CurrentCellInfo.Item)).Probability.Value;

                // Reflect totaling changes in the following types of columns when the data in the Forecast Revenue Columns Change:
                //  1. Weighted Revenue
                //  2. Q1/Q2/Q3/Q4
                //  3. Weighted Q1/Q2/Q3/Q4
                //  4. Total
                //  5. Weighted Total
                //  6. Yield Revenue

                if (e.Cell.Column.UniqueName == "SALES_REVENUE")
                {

                    //e.Cell.ParentRow.Cells[e.Cell.Column.DisplayIndex].Content = e.NewData.ToString();
                   
                   
                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "YIELD_REVENUE")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {

                        ((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "YIELD_REVENUE")].Content)).Text = (Convert.ToDecimal(e.NewData) * Probability / (100)).ToString();

                    }

                }

                if ((e.Cell.Column.UniqueName == "FY_September") || (e.Cell.Column.UniqueName == "FY_October") || (e.Cell.Column.UniqueName == "FY_November"))
                {

                    if (e.Cell.Column.UniqueName == "FY_September")
                    {

                        _FY_Sep = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content = Weighted_FY_Sep = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q1")].Content = Weighted_FY_Sep + Weighted_FY_Oct + Weighted_FY_Nov;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q1")].Content = _FY_Sep + _FY_Oct + _FY_Nov;

                    }

                    else if (e.Cell.Column.UniqueName == "FY_October")
                    {

                        _FY_Oct = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content = Weighted_FY_Oct = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q1")].Content = Weighted_FY_Sep + Weighted_FY_Oct + Weighted_FY_Nov;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q1")].Content = _FY_Sep + _FY_Oct + _FY_Nov;

                    }

                    else if (e.Cell.Column.UniqueName == "FY_November")
                    {
                        _FY_Nov = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content = Weighted_FY_Nov = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q1")].Content = Weighted_FY_Sep + Weighted_FY_Oct + Weighted_FY_Nov;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q1")].Content = _FY_Sep + _FY_Oct + _FY_Nov;

                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content)).Text);

                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content)).Text);
                    }

 

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content)).Text);
                    }

 

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content)).Text);
                    }

 

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content)).Text);
                    }

                    e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Total")].Content = Weighted_FY_Sep + Weighted_FY_Oct + Weighted_FY_Nov + Weighted_FY_Dec + Weighted_FY_Jan + Weighted_FY_Feb + Weighted_FY_Mar + Weighted_FY_April + Weighted_FY_May + Weighted_FY_June + Weighted_FY_July + Weighted_FY_Aug;

                    e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Total")].Content = _FY_Sep + _FY_Oct + _FY_Nov + _FY_Dec + _FY_Jan + _FY_Feb + _FY_Mar + _FY_April + _FY_May + _FY_June + _FY_July + _FY_Aug;
                }

                else if ((e.Cell.Column.UniqueName == "FY_December") || (e.Cell.Column.UniqueName == "FY_January") || (e.Cell.Column.UniqueName == "FY_February"))
                {
                    if (e.Cell.Column.UniqueName == "FY_December")
                    {

                        _FY_Dec = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content = Weighted_FY_Dec = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q2")].Content = Weighted_FY_Dec + Weighted_FY_Jan + Weighted_FY_Feb;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q2")].Content = _FY_Dec + _FY_Jan + _FY_Feb;
                    }

                    else if (e.Cell.Column.UniqueName == "FY_January")
                    {
                        _FY_Jan = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content = Weighted_FY_Jan = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q2")].Content = Weighted_FY_Dec + Weighted_FY_Jan + Weighted_FY_Feb;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q2")].Content = _FY_Dec + _FY_Jan + _FY_Feb;
                    }

                    else if (e.Cell.Column.UniqueName == "FY_February")
                    {
                        _FY_Feb = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content = Weighted_FY_Feb = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q2")].Content = Weighted_FY_Dec + Weighted_FY_Jan + Weighted_FY_Feb;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q2")].Content = _FY_Dec + _FY_Jan + _FY_Feb;
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content)).Text);
                    }

 

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content)).Text);
                    }

 

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content)).Text);
                    }

                    e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Total")].Content = Weighted_FY_Sep + Weighted_FY_Oct + Weighted_FY_Nov + Weighted_FY_Dec + Weighted_FY_Jan + Weighted_FY_Feb + Weighted_FY_Mar + Weighted_FY_April + Weighted_FY_May + Weighted_FY_June + Weighted_FY_July + Weighted_FY_Aug;

                    e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Total")].Content = _FY_Sep + _FY_Oct + _FY_Nov + _FY_Dec + _FY_Jan + _FY_Feb + _FY_Mar + _FY_April + _FY_May + _FY_June + _FY_July + _FY_Aug;

                }

                else if ((e.Cell.Column.UniqueName == "FY_March") || (e.Cell.Column.UniqueName == "FY_April") || (e.Cell.Column.UniqueName == "FY_May"))
                {

                    if (e.Cell.Column.UniqueName == "FY_March")
                    {

                        _FY_Mar = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content = Weighted_FY_Mar = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q3")].Content = Weighted_FY_Mar + Weighted_FY_April + Weighted_FY_May;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q3")].Content = _FY_Mar + _FY_April + _FY_May;

                    }

                    else if (e.Cell.Column.UniqueName == "FY_April")
                    {

                        _FY_April = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content = Weighted_FY_April = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q3")].Content = Weighted_FY_Mar + Weighted_FY_April + Weighted_FY_May;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q3")].Content = _FY_Mar + _FY_April + _FY_May;

                    }

                    else if (e.Cell.Column.UniqueName == "FY_May")
                    {

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content)).Text);
                        }

                        _FY_May = Convert.ToDecimal(e.NewData);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content = Weighted_FY_May = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q3")].Content = Weighted_FY_Mar + Weighted_FY_April + Weighted_FY_May;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q3")].Content = _FY_Mar + _FY_April + _FY_May;

                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content)).Text);
                    }

 

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content)).Text);
                    }

 

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content)).Text);
                    }

                    e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Total")].Content = Weighted_FY_Sep + Weighted_FY_Oct + Weighted_FY_Nov + Weighted_FY_Dec + Weighted_FY_Jan + Weighted_FY_Feb + Weighted_FY_Mar + Weighted_FY_April + Weighted_FY_May + Weighted_FY_June + Weighted_FY_July + Weighted_FY_Aug;

                    e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Total")].Content = _FY_Sep + _FY_Oct + _FY_Nov + _FY_Dec + _FY_Jan + _FY_Feb + _FY_Mar + _FY_April + _FY_May + _FY_June + _FY_July + _FY_Aug;

                }

                else if ((e.Cell.Column.UniqueName == "FY_June") || (e.Cell.Column.UniqueName == "FY_July") || (e.Cell.Column.UniqueName == "FY_August"))
                {

                    if (e.Cell.Column.UniqueName == "FY_June")
                    {
                        _FY_June = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content)).Text);
                        }

 

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content = Weighted_FY_June = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q4")].Content = Weighted_FY_June + Weighted_FY_July + Weighted_FY_Aug;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q4")].Content = _FY_June + _FY_July + _FY_Aug;

                    }

                    else if (e.Cell.Column.UniqueName == "FY_July")
                    {
                        _FY_July = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_August")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content = Weighted_FY_July = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q4")].Content = Weighted_FY_June + Weighted_FY_July + Weighted_FY_Aug;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q4")].Content = _FY_June + _FY_July + _FY_Aug;

                    }

                    else if (e.Cell.Column.UniqueName == "FY_August")
                    {
                        _FY_Aug = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_July")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_June")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_July")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_June")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_August")].Content = Weighted_FY_Aug = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Q4")].Content = Weighted_FY_June + Weighted_FY_July + Weighted_FY_Aug;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Q4")].Content = _FY_June + _FY_July + _FY_Aug;
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_September")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_October")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_November")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_December")].Content)).Text);

                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_January")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_February")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_March")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_April")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_May")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_September")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_October")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_November")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_December")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_January")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_February")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_March")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_April = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_April")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_May")].Content)).Text);
                    }

                    e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_Total")].Content = Weighted_FY_Sep + Weighted_FY_Oct + Weighted_FY_Nov + Weighted_FY_Dec + Weighted_FY_Jan + Weighted_FY_Feb + Weighted_FY_Mar + Weighted_FY_April + Weighted_FY_May + Weighted_FY_June + Weighted_FY_July + Weighted_FY_Aug;

                    e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_Total")].Content = _FY_Sep + _FY_Oct + _FY_Nov + _FY_Dec + _FY_Jan + _FY_Feb + _FY_Mar + _FY_April + _FY_May + _FY_June + _FY_July + _FY_Aug;

                }

                else if ((e.Cell.Column.UniqueName == "FY_1_September") || (e.Cell.Column.UniqueName == "FY_1_October") || (e.Cell.Column.UniqueName == "FY_1_November"))
                {

                    if (e.Cell.Column.UniqueName == "FY_1_September")
                    {

                        _FY_1_Sep = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content = Weighted_FY_1_Sep = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q1")].Content = Weighted_FY_1_Sep + Weighted_FY_1_Oct + Weighted_FY_1_Nov;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q1")].Content = _FY_1_Sep + _FY_1_Oct + _FY_1_Nov;

                    }

                    else if (e.Cell.Column.UniqueName == "FY_1_October")
                    {
                        _FY_1_Oct = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content = Weighted_FY_1_Oct = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q1")].Content = Weighted_FY_1_Sep + Weighted_FY_1_Oct + Weighted_FY_1_Nov;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q1")].Content = _FY_1_Sep + _FY_1_Oct + _FY_1_Nov;

                    }

                    else if (e.Cell.Column.UniqueName == "FY_1_November")
                    {
                        _FY_1_Nov = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content = Weighted_FY_1_Nov = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q1")].Content = Weighted_FY_1_Sep + Weighted_FY_1_Oct + Weighted_FY_1_Nov;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q1")].Content = _FY_1_Sep + _FY_1_Oct + _FY_1_Nov;
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content)).Text);
                    }

                    e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Total")].Content = _FY_1_Sep + _FY_1_Oct + _FY_1_Nov + _FY_1_Dec + _FY_1_Jan + _FY_1_Feb + _FY_1_Mar + _FY_1_Apr + _FY_1_May + _FY_1_June + _FY_1_July + _FY_1_Aug;

                    e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Total")].Content = Weighted_FY_1_Sep + Weighted_FY_1_Oct + Weighted_FY_1_Nov + Weighted_FY_1_Dec + Weighted_FY_1_Jan + Weighted_FY_1_Feb + Weighted_FY_1_Mar + Weighted_FY_1_Apr + Weighted_FY_1_May + Weighted_FY_1_June + Weighted_FY_1_July + Weighted_FY_1_Aug;

                }

                else if ((e.Cell.Column.UniqueName == "FY_1_December") || (e.Cell.Column.UniqueName == "FY_1_January") || (e.Cell.Column.UniqueName == "FY_1_February"))
                {

                    if (e.Cell.Column.UniqueName == "FY_1_December")
                    {
                        _FY_1_Dec = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content = Weighted_FY_1_Dec = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q2")].Content = Weighted_FY_1_Dec + Weighted_FY_1_Jan + Weighted_FY_1_Feb;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q2")].Content = _FY_1_Dec + _FY_1_Jan + _FY_1_Feb;
                    }

                    else if (e.Cell.Column.UniqueName == "FY_1_January")
                    {
                        _FY_1_Jan = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content = Weighted_FY_1_Jan = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q2")].Content = Weighted_FY_1_Dec + Weighted_FY_1_Jan + Weighted_FY_1_Feb;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q2")].Content = _FY_1_Dec + _FY_1_Jan + _FY_1_Feb;

                    }

                    else if (e.Cell.Column.UniqueName == "FY_1_February")
                    {
                        _FY_1_Feb = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content = Weighted_FY_1_Feb = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q2")].Content = Weighted_FY_1_Dec + Weighted_FY_1_Jan + Weighted_FY_1_Feb;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q2")].Content = _FY_1_Dec + _FY_1_Jan + _FY_1_Feb;

                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content)).Text);
                    }

                    e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Total")].Content = _FY_1_Sep + _FY_1_Oct + _FY_1_Nov + _FY_1_Dec + _FY_1_Jan + _FY_1_Feb + _FY_1_Mar + _FY_1_Apr + _FY_1_May + _FY_1_June + _FY_1_July + _FY_1_Aug;

                    e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Total")].Content = Weighted_FY_1_Sep + Weighted_FY_1_Oct + Weighted_FY_1_Nov + Weighted_FY_1_Dec + Weighted_FY_1_Jan + Weighted_FY_1_Feb + Weighted_FY_1_Mar + Weighted_FY_1_Apr + Weighted_FY_1_May + Weighted_FY_1_June + Weighted_FY_1_July + Weighted_FY_1_Aug;

                }

                else if ((e.Cell.Column.UniqueName == "FY_1_March") || (e.Cell.Column.UniqueName == "FY_1_April") || (e.Cell.Column.UniqueName == "FY_1_May"))
                {

                    if (e.Cell.Column.UniqueName == "FY_1_March")
                    {
                        _FY_1_Mar = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content = Weighted_FY_1_Mar = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q3")].Content = Weighted_FY_1_Mar + Weighted_FY_1_Apr + Weighted_FY_1_May;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q3")].Content = _FY_1_Mar + _FY_1_Apr + _FY_1_May;

                    }

                    else if (e.Cell.Column.UniqueName == "FY_1_April")
                    {
                        _FY_1_Apr = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content = Weighted_FY_1_Apr = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q3")].Content = Weighted_FY_1_Mar + Weighted_FY_1_Apr + Weighted_FY_1_May;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q3")].Content = _FY_1_Mar + _FY_1_Apr + _FY_1_May;

                    }

                    else if (e.Cell.Column.UniqueName == "FY_1_May")
                    {

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content)).Text);
                        }

                        _FY_1_May = Convert.ToDecimal(e.NewData);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content = Weighted_FY_1_May = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q3")].Content = Weighted_FY_1_Mar + Weighted_FY_1_Apr + Weighted_FY_1_May;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q3")].Content = _FY_1_Mar + _FY_1_Apr + _FY_1_May;

                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content)).Text);
                    }

                    e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Total")].Content = _FY_1_Sep + _FY_1_Oct + _FY_1_Nov + _FY_1_Dec + _FY_1_Jan + _FY_1_Feb + _FY_1_Mar + _FY_1_Apr + _FY_1_May + _FY_1_June + _FY_1_July + _FY_1_Aug;

                    e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Total")].Content = Weighted_FY_1_Sep + Weighted_FY_1_Oct + Weighted_FY_1_Nov + Weighted_FY_1_Dec + Weighted_FY_1_Jan + Weighted_FY_1_Feb + Weighted_FY_1_Mar + Weighted_FY_1_Apr + Weighted_FY_1_May + Weighted_FY_1_June + Weighted_FY_1_July + Weighted_FY_1_Aug;

                }

                else if ((e.Cell.Column.UniqueName == "FY_1_June") || (e.Cell.Column.UniqueName == "FY_1_July") || (e.Cell.Column.UniqueName == "FY_1_August"))
                {

                    if (e.Cell.Column.UniqueName == "FY_1_June")
                    {
                        _FY_1_June = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content = Weighted_FY_1_June = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q4")].Content = Weighted_FY_1_June + Weighted_FY_1_July + Weighted_FY_1_Aug;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q4")].Content = _FY_1_June + _FY_1_July + _FY_1_Aug;
                    }

                    else if (e.Cell.Column.UniqueName == "FY_1_July")
                    {
                        _FY_1_July = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_August")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_Aug = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content = Weighted_FY_1_July = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q4")].Content = Weighted_FY_1_June + Weighted_FY_1_July + Weighted_FY_1_Aug;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q4")].Content = _FY_1_June + _FY_1_July + _FY_1_Aug;

                    }

                    else if (e.Cell.Column.UniqueName == "FY_1_August")
                    {
                        _FY_1_Aug = Convert.ToDecimal(e.NewData);

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_July")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            _FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_June")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_July = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_July")].Content)).Text);
                        }

                        if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                        {
                            Weighted_FY_1_June = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_June")].Content)).Text);
                        }

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_August")].Content = Weighted_FY_1_Aug = ToolUtilities.CalculatedWeightedRevenue(Convert.ToDecimal(e.NewData), Probability);

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Q4")].Content = Weighted_FY_1_June + Weighted_FY_1_July + Weighted_FY_1_Aug;

                        e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Q4")].Content = _FY_1_June + _FY_1_July + _FY_1_Aug; ;

                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_September")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_October")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_November")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_December")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_January")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_February")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_March")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_April")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        _FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_May")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Sep = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_September")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Oct = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_October")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Nov = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_November")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Dec = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_December")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Jan = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_January")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Feb = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_February")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Mar = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_March")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_Apr = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_April")].Content)).Text);
                    }

                    if (e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content.GetType().FullName == "System.Windows.Controls.TextBlock")
                    {
                        Weighted_FY_1_May = Convert.ToDecimal(((System.Windows.Controls.TextBlock)(e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_May")].Content)).Text);
                    }

                    e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "FY_1_Total")].Content = _FY_1_Sep + _FY_1_Oct + _FY_1_Nov + _FY_1_Dec + _FY_1_Jan + _FY_1_Feb + _FY_1_Mar + _FY_1_Apr + _FY_1_May + _FY_1_June + _FY_1_July + _FY_1_Aug;

                    e.Cell.ParentRow.Cells[ToolUtilities.GetCellIndexFromGrid(radGridView, "W_FY_1_Total")].Content = Weighted_FY_1_Sep + Weighted_FY_1_Oct + Weighted_FY_1_Nov + Weighted_FY_1_Dec + Weighted_FY_1_Jan + Weighted_FY_1_Feb + Weighted_FY_1_Mar + Weighted_FY_1_Apr + Weighted_FY_1_May + Weighted_FY_1_June + Weighted_FY_1_July + Weighted_FY_1_Aug;

                }

            }

            catch (Exception excep)
            {

                MessageBox.Show(excep.Message.ToString());

            }
            
           
        }

        */

 

       /*
       private void UpdateRow_Click(object sender, RoutedEventArgs e)
       {

           SaveButton.IsEnabled = false;

           RevenueProjectionToolWCFService.RevenueProjectionToolServiceClient WcfSvc = new Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.RevenueProjectionToolServiceClient();
          
           string oppId = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).OpportunityGUID.Value.ToString();

           string RevType = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).REVENUE_TYPE;

           decimal RevAmt = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).SALES_REVENUE.Value;

           long EffortDays = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).EffortDays.Value;

           string EstimatedPrjStDt = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).EstimatedProjStDt.Value.ToString("o").Replace('-', '/');

           string oppName = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).OpportunityName;

           string forecastId = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).ForecastGUID.Value.ToString();

           int Duration = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).Duration.Value;

           int Revenue_Type_N = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).REVENUE_TYPE_N.Value;
          
           WcfSvc.UpdateOpportunityInCRMAsync(oppId, RevType, RevAmt, EffortDays, EstimatedPrjStDt);

           decimal fy_sep = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_September.Value;

           if (fy_sep > 0)
           {
               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "September";
               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "September";
               }
              
                           
               string fy_sep_Id = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_September_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_sep, Forecast_Detail_Record_Name, Duration, RevAmt, fy_sep_Id, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

          
           decimal fy_oct = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_October.Value;

           if (fy_oct > 0)
           {
               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "October";
               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "October";
               }
                           
               string fy_oct_Id = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_October_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_sep, Forecast_Detail_Record_Name, Duration, RevAmt, fy_oct_Id, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

           decimal fy_nov = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_November.Value;

           if (fy_nov > 0)
           {
               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "November";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "November";
               }
                            
               string fy_nov_Id = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_November_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_nov, Forecast_Detail_Record_Name, Duration, RevAmt, fy_nov_Id, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

           decimal fy_dec = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_December.Value;

           if (fy_dec > 0)
           {

               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "December";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "December";
               }
            
               string fy_dec_Id = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_December_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_dec, Forecast_Detail_Record_Name, Duration, RevAmt, fy_dec_Id, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

           decimal fy_jan = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_January.Value;

           if (fy_jan > 0)
           {
               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "January";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "January";
               }
                          
               string fy_jan_Id = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_January_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_jan, Forecast_Detail_Record_Name, Duration, RevAmt, fy_jan_Id, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

           decimal fy_feb = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_February.Value;

           if (fy_feb > 0)
           {
               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "February";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "February";
               }
                             
               string fy_feb_Id = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_February_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_feb, Forecast_Detail_Record_Name, Duration, RevAmt, fy_feb_Id, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

           decimal fy_mar = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_March.Value;
          
           if (fy_mar > 0)
           {

               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "March";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "March";
               }
                             
               string fy_mar_Id = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_March_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_mar, Forecast_Detail_Record_Name, Duration, RevAmt, fy_mar_Id, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

           decimal fy_apr = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_April.Value;

           if (fy_apr > 0)
           {
               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "April";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "April";
               }
                        
               string fy_apr_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_April_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_apr, Forecast_Detail_Record_Name, Duration, RevAmt, fy_apr_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

          decimal fy_may = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_May.Value;

          if (fy_may > 0)
           {

               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "May";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "May";
               }
             
                      
               string fy_may_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_May_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_may, Forecast_Detail_Record_Name, Duration, RevAmt, fy_may_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

          decimal fy_june = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_June.Value;

          if (fy_june > 0)
           {
              
              string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "June";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "June";
               }
                                        
               string fy_june_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_June_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_june, Forecast_Detail_Record_Name, Duration, RevAmt, fy_june_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

          decimal fy_July = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_July.Value;

          if (fy_July > 0)
           {
               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "July";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "July";
               }
             
              string fy_july_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_July_ID;

              WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_July, Forecast_Detail_Record_Name, Duration, RevAmt, fy_july_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

          decimal fy_aug = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_August.Value;

           if (fy_aug > 0)
          
           {

               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear).ToString() + "-" + "August";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "August";
               }
              
                            
               string fy_aug_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_August_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_aug, Forecast_Detail_Record_Name, Duration, RevAmt, fy_aug_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

           decimal fy_1_sep = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_September.Value;

           if (fy_1_sep > 0)
           {

               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "September";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "September";
               }
                             
               string fy_1_sep_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_September_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_sep, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_sep_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

           decimal fy_1_oct = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_October.Value;

           if (fy_1_oct > 0)
           {
               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "October";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "October";
               }
                            
               string fy_1_oct_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_October_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_oct, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_oct_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

           decimal fy_1_nov = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_November.Value;

           if (fy_1_nov > 0)
           {

               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "November";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "November";
               }
              
            
               string fy_1_nov_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_November_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_nov, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_nov_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

           decimal fy_1_dec = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_December.Value;

           if (fy_1_dec > 0)
           {

               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "December";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "December";
               }
                          
               string fy_1_dec_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_December_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_dec, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_dec_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

         

           decimal fy_1_jan = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_January.Value;

           if (fy_1_jan > 0)
           {

               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "January";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "January";
               }
                          
               string fy_1_jan_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_January_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_jan, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_jan_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

         

           decimal fy_1_feb = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_February.Value;

           if (fy_1_feb > 0)
           {
               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "February";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "February";
               }
              
              
              
               string fy_1_feb_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_February_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_feb, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_feb_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

        

          decimal fy_1_mar = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_March.Value;

          if (fy_1_mar > 0)
           {
               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "March";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "March";
               }
                           
               string fy_1_mar_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_March_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_mar, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_mar_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

         

          decimal fy_1_apr = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_April.Value;

          if (fy_1_apr > 0)
           {

               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "April";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "April";
               }
                       
               string fy_1_apr_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_April_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_apr, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_apr_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

           decimal fy_1_may = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_May.Value;

           if (fy_1_may > 0)
           {

               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "May";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "May";
               }
              
                      
               string fy_1_may_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_May_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_may, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_may_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

           decimal fy_1_june = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_June.Value;

           if (fy_1_june > 0)
           {
               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "June";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "June";
               }
                          
               string fy_1_june_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_June_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_june, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_june_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

           decimal fy_1_july = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_July.Value;

           if (fy_1_july > 0)
           {

               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "July";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "July";
               }
              
               string fy_1_july_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_July_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_july, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_july_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

           decimal fy_1_aug = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_August.Value;

           if (fy_1_aug > 0 )
           {
               string Forecast_Detail_Record_Name = "";

               if (CurrentMonth < 9)
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 1).ToString() + "-" + "August";

               }

               else
               {
                   Forecast_Detail_Record_Name = "FY" + (CurrentYear + 2).ToString() + "-" + "August";
               }
              
              
               string fy_1_aug_ID = ((Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.GetRevenueProjection_Result)(((System.Windows.FrameworkElement)(sender)).DataContext)).FY_1_August_ID;

               WcfSvc.UpdateOrCreateForecastDetailsInCRMAsync(forecastId, oppId, fy_1_aug, Forecast_Detail_Record_Name, Duration, RevAmt, fy_1_aug_ID, Revenue_Type_N, oppName, EstimatedPrjStDt);
           }

 

       }

        */
      
       [ScriptableMember]

       public string ToHtml()
       {
           return radGridView.ToHtml(true, true);
       }

       [ScriptableMember]

       public string ToCsv()
       {
           return radGridView.ToCsv(true, true);
       }

       [ScriptableMember]

       public string ToExcelXML()
       {
           return radGridView.ToExcelML(true, true);
       }

       private void btn_Save(object sender, RoutedEventArgs e)
       {

           GridViewRow[] EditedRowToArray = EditedRowData.ToArray();
          
           RevenueProjectionToolWCFService.RevenueProjectionToolServiceClient WcfSvc = new Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.RevenueProjectionToolServiceClient();

           WcfSvc.UpdateCRMDataAsync(EditedRowToArray as object);
       }

       private void ShowDataButton_Click(object sender, RoutedEventArgs e)
       {

           try
           {
               if (RegionNames.Count == 0)
               {
                   // Show an alert message to the User

                   RadWindow radWin = new RadWindow();
                   radWin.Top = 350;
                   radWin.Left = 550;
                   radWin.Width = 370;
                   radWin.Height = 50;
                   radWin.Header = "No Region Selected";
                   radWin.Content = "Please select atleast 1 Region from which data must be fetched";
                   radWin.Show();
               }

               else
               {
                  
                   StartingRow = InitialStartingRow;

                   PageSize = InitialPageSize;

                   ShowDataButton.IsEnabled = false;

                   if(IGrpDescArr != null)
                   {

                       radGridView.GroupDescriptors.Remove(IGrpDescArr[0]);                 
                   }
                  
                   GetData();

               }
           }

           catch (Exception Excep)
           {

               MessageBox.Show(Excep.InnerException.StackTrace.ToString() + Excep.Message.ToString());
          
           }

       }

       private void GetData()
       {
           
           RevenueProjectionToolWCFService.RevenueProjectionToolServiceClient ws = new Avanade.Crm.Sam.RPT.RevenueProjectionToolWCFService.RevenueProjectionToolServiceClient();

           ws.GetRevenueProjectionToolDataPageWiseCompleted += new EventHandler<GetRevenueProjectionToolDataPageWiseCompletedEventArgs>(ws_RevenueProjectionToolDataPageWiseCompleted);

           ws.GetRevenueProjectionToolDataPageWiseAsync(true, StartingRow, PageSize, RegionNames,this.AccountAutoCompleteBox.Text.ToString(), this.BDOwnerAutoCompleteBox.Text.ToString());
                
       }
 
       private void ShowHideColumnsOptions(object sender, RoutedEventArgs e)
       {

       }

       private void ExportToExcel(object sender, RoutedEventArgs e)
       {
           ExportFormat format = ExportFormat.Html;
           string extension = "xlsx";

           SaveFileDialog dialog = new SaveFileDialog();
           dialog.DefaultExt = extension;
           dialog.Filter = String.Format("{1} files (*.{0})|*.{0}|All files (*.*)|*.*", extension);
           dialog.FilterIndex = 1;

           if (dialog.ShowDialog() == true)
           {
               using (Stream stream = dialog.OpenFile())
               {
                   GridViewExportOptions exportOptions = new GridViewExportOptions();

                   exportOptions.Format = format;
                   exportOptions.ShowColumnFooters = true;
                   exportOptions.ShowColumnHeaders = true;
                   exportOptions.ShowGroupFooters = true;

                   radGridView.Export(stream, exportOptions);

               }
           }

       }

       private void DisplayRevenueInUSDAndLCY_Click(object sender, RoutedEventArgs e)
       {

           DisplayRevenueInUSDAndLCY.IsEnabled = false;

           ShowOrHideUSDColumns ShowColumns = new ShowOrHideUSDColumns();

           if (DisplayRevenueInUSDAndLCY.Content.ToString() == "Show Revenue in USD")
           {
              
               ShowOrHideUSDColumns.ShowUSDColumns(radGridView);

               ToolUtilities.GenerateColumnHeadersUSDColumns(radGridView);
              
               ShowOrHideUSDColumns.HideLCYColumns(radGridView);

               decimal[] CalculatedColumnFooterTotals = CalculatedColumnsFooterTotals.CalculateTotalsForCalculatedColumnsUSD(RPTDataArray);

               this.SetValueInColumnFooter("YIELD_REVENUE_BASE", decimal.Round(CalculatedColumnFooterTotals[0], 2));
               this.SetValueInColumnFooter("FY_Q1_BASE", decimal.Round(CalculatedColumnFooterTotals[1], 2));
               this.SetValueInColumnFooter("FY_Q2_BASE", decimal.Round(CalculatedColumnFooterTotals[2], 2));
               this.SetValueInColumnFooter("FY_Q3_BASE", decimal.Round(CalculatedColumnFooterTotals[3], 2));
               this.SetValueInColumnFooter("FY_Q4_BASE", decimal.Round(CalculatedColumnFooterTotals[4], 2));
               this.SetValueInColumnFooter("FY_Total_BASE", decimal.Round(CalculatedColumnFooterTotals[5], 2));
               this.SetValueInColumnFooter("FY_1_Q1_BASE", decimal.Round(CalculatedColumnFooterTotals[6], 2));
               this.SetValueInColumnFooter("FY_1_Q2_BASE", decimal.Round(CalculatedColumnFooterTotals[7], 2));
               this.SetValueInColumnFooter("FY_1_Q3_BASE", decimal.Round(CalculatedColumnFooterTotals[8], 2));
               this.SetValueInColumnFooter("FY_1_Q4_BASE", decimal.Round(CalculatedColumnFooterTotals[9], 2));
               this.SetValueInColumnFooter("FY_1_Total_BASE", decimal.Round(CalculatedColumnFooterTotals[10], 2));

               this.SetValueInColumnFooter("W_FY_September_BASE", decimal.Round(CalculatedColumnFooterTotals[11], 2));
               this.SetValueInColumnFooter("W_FY_October_BASE", decimal.Round(CalculatedColumnFooterTotals[12], 2));
               this.SetValueInColumnFooter("W_FY_November_BASE", decimal.Round(CalculatedColumnFooterTotals[13], 2));
               this.SetValueInColumnFooter("W_FY_Q1_BASE", decimal.Round(CalculatedColumnFooterTotals[14], 2));
              
               this.SetValueInColumnFooter("W_FY_December_BASE", decimal.Round(CalculatedColumnFooterTotals[15], 2));
               this.SetValueInColumnFooter("W_FY_January_BASE", decimal.Round(CalculatedColumnFooterTotals[16], 2));
               this.SetValueInColumnFooter("W_FY_February_BASE", decimal.Round(CalculatedColumnFooterTotals[17], 2));
               this.SetValueInColumnFooter("W_FY_Q2_BASE", decimal.Round(CalculatedColumnFooterTotals[18], 2));

               this.SetValueInColumnFooter("W_FY_March_BASE", decimal.Round(CalculatedColumnFooterTotals[19], 2));
               this.SetValueInColumnFooter("W_FY_April_BASE", decimal.Round(CalculatedColumnFooterTotals[20], 2));
               this.SetValueInColumnFooter("W_FY_May_BASE", decimal.Round(CalculatedColumnFooterTotals[21], 2));
               this.SetValueInColumnFooter("W_FY_Q3_BASE", decimal.Round(CalculatedColumnFooterTotals[22], 2));
               this.SetValueInColumnFooter("W_FY_June_BASE", decimal.Round(CalculatedColumnFooterTotals[23], 2));
               this.SetValueInColumnFooter("W_FY_July_BASE", decimal.Round(CalculatedColumnFooterTotals[24], 2));
               this.SetValueInColumnFooter("W_FY_August_BASE", decimal.Round(CalculatedColumnFooterTotals[25], 2));
               this.SetValueInColumnFooter("W_FY_Q4_BASE", decimal.Round(CalculatedColumnFooterTotals[26], 2));
               this.SetValueInColumnFooter("W_FY_Total_BASE", decimal.Round(CalculatedColumnFooterTotals[27], 2));

               this.SetValueInColumnFooter("W_FY_1_September_BASE", decimal.Round(CalculatedColumnFooterTotals[28], 2));
               this.SetValueInColumnFooter("W_FY_1_October_BASE", decimal.Round(CalculatedColumnFooterTotals[29], 2));
               this.SetValueInColumnFooter("W_FY_1_November_BASE", decimal.Round(CalculatedColumnFooterTotals[30], 2));
               this.SetValueInColumnFooter("W_FY_1_Q1_BASE", decimal.Round(CalculatedColumnFooterTotals[31], 2));

               this.SetValueInColumnFooter("W_FY_1_December_BASE", decimal.Round(CalculatedColumnFooterTotals[32], 2));
               this.SetValueInColumnFooter("W_FY_1_January_BASE", decimal.Round(CalculatedColumnFooterTotals[33], 2));
               this.SetValueInColumnFooter("W_FY_1_February_BASE", decimal.Round(CalculatedColumnFooterTotals[34], 2));
               this.SetValueInColumnFooter("W_FY_1_Q2_BASE", decimal.Round(CalculatedColumnFooterTotals[35], 2));

               this.SetValueInColumnFooter("W_FY_1_March_BASE", decimal.Round(CalculatedColumnFooterTotals[36], 2));
               this.SetValueInColumnFooter("W_FY_1_April_BASE", decimal.Round(CalculatedColumnFooterTotals[37], 2));
               this.SetValueInColumnFooter("W_FY_1_May_BASE", decimal.Round(CalculatedColumnFooterTotals[38], 2));
               this.SetValueInColumnFooter("W_FY_1_Q3_BASE", decimal.Round(CalculatedColumnFooterTotals[39], 2));
               this.SetValueInColumnFooter("W_FY_1_June_BASE", decimal.Round(CalculatedColumnFooterTotals[40], 2));
               this.SetValueInColumnFooter("W_FY_1_July_BASE", decimal.Round(CalculatedColumnFooterTotals[41], 2));
               this.SetValueInColumnFooter("W_FY_1_August_BASE", decimal.Round(CalculatedColumnFooterTotals[42], 2));
               this.SetValueInColumnFooter("W_FY_1_Q4_BASE", decimal.Round(CalculatedColumnFooterTotals[43], 2));
               this.SetValueInColumnFooter("W_FY_1_Total_BASE", decimal.Round(CalculatedColumnFooterTotals[44], 2));

               this.SetValueInColumnFooter("FY_September_BASE", decimal.Round(CalculatedColumnFooterTotals[45], 2));
               this.SetValueInColumnFooter("FY_October_BASE", decimal.Round(CalculatedColumnFooterTotals[46], 2));
               this.SetValueInColumnFooter("FY_November_BASE", decimal.Round(CalculatedColumnFooterTotals[47], 2));
               this.SetValueInColumnFooter("FY_December_BASE", decimal.Round(CalculatedColumnFooterTotals[48], 2));
               this.SetValueInColumnFooter("FY_January_BASE", decimal.Round(CalculatedColumnFooterTotals[49], 2));
               this.SetValueInColumnFooter("FY_February_BASE", decimal.Round(CalculatedColumnFooterTotals[50], 2));
               this.SetValueInColumnFooter("FY_March_BASE", decimal.Round(CalculatedColumnFooterTotals[51], 2));
               this.SetValueInColumnFooter("FY_April_BASE", decimal.Round(CalculatedColumnFooterTotals[52], 2));
               this.SetValueInColumnFooter("FY_May_BASE", decimal.Round(CalculatedColumnFooterTotals[53], 2));
               this.SetValueInColumnFooter("FY_June_BASE", decimal.Round(CalculatedColumnFooterTotals[54], 2));
               this.SetValueInColumnFooter("FY_July_BASE", decimal.Round(CalculatedColumnFooterTotals[55], 2));
               this.SetValueInColumnFooter("FY_August_BASE", decimal.Round(CalculatedColumnFooterTotals[56], 2));

              
               this.SetValueInColumnFooter("FY_1_September_BASE", decimal.Round(CalculatedColumnFooterTotals[57], 2));
               this.SetValueInColumnFooter("FY_1_October_BASE", decimal.Round(CalculatedColumnFooterTotals[58], 2));
               this.SetValueInColumnFooter("FY_1_November_BASE", decimal.Round(CalculatedColumnFooterTotals[59], 2));
               this.SetValueInColumnFooter("FY_1_December_BASE", decimal.Round(CalculatedColumnFooterTotals[60], 2));
               this.SetValueInColumnFooter("FY_1_January_BASE", decimal.Round(CalculatedColumnFooterTotals[61], 2));
               this.SetValueInColumnFooter("FY_1_February_BASE", decimal.Round(CalculatedColumnFooterTotals[62], 2));
               this.SetValueInColumnFooter("FY_1_March_BASE", decimal.Round(CalculatedColumnFooterTotals[63], 2));
               this.SetValueInColumnFooter("FY_1_April_BASE", decimal.Round(CalculatedColumnFooterTotals[64], 2));
               this.SetValueInColumnFooter("FY_1_May_BASE", decimal.Round(CalculatedColumnFooterTotals[65], 2));
               this.SetValueInColumnFooter("FY_1_June_BASE", decimal.Round(CalculatedColumnFooterTotals[66], 2));
               this.SetValueInColumnFooter("FY_1_July_BASE", decimal.Round(CalculatedColumnFooterTotals[67], 2));
               this.SetValueInColumnFooter("FY_1_August_BASE", decimal.Round(CalculatedColumnFooterTotals[68], 2));

               this.SetValueInColumnFooter("SALES_REVENUE_BASE", decimal.Round(CalculatedColumnFooterTotals[69], 2));

               radGridView.GroupDescriptors.Remove(IGrpDescArr[0]);

               DisplayRevenueInUSDAndLCY.Content = "Show Revenue in LCY";

           }

           else if (DisplayRevenueInUSDAndLCY.Content.ToString() == "Show Revenue in LCY")
           {
            
               ShowOrHideUSDColumns.HideUSDColumns(radGridView);

               ShowOrHideUSDColumns.ShowLCYColumns(radGridView);

               radGridView.GroupDescriptors.Add(IGrpDescArr[0]);

               DisplayRevenueInUSDAndLCY.Content = "Show Revenue in USD";

           }

           DisplayRevenueInUSDAndLCY.IsEnabled = true;

       }

       private void RegionCheckBox_Checked(object sender, RoutedEventArgs e)
       {

           RegionNames.Add(((System.Windows.Controls.ContentControl)(sender)).Content.ToString());

       }

       private void RegionCheckBox_UnChecked(object sender, RoutedEventArgs e)
       {

           RegionNames.Remove(((System.Windows.Controls.ContentControl)(sender)).Content.ToString());
       }

        
        
       private void radGridView_CellValidating(object sender, GridViewCellValidatingEventArgs e)
       {

           for (int p = 0; p < EditableColumnUniqueNames.Length; p++)
           {

               if (e.Cell.Column.UniqueName == EditableColumnUniqueNames[p])
               {

                   if (Regex.IsMatch(e.NewValue.ToString(), "[0-9]+"))
                   {

                       if (Convert.ToDecimal(e.NewValue) < 0)
                       {

                           e.IsValid = false;

                           e.ErrorMessage = "Please enter a positive value.";

                      
                       }

                   }

                   else
                   {

                       e.IsValid = false;

                       e.ErrorMessage = "Please enter a numeric value.";
                  
                  
                   }

               }

               

           }

       }
         
      

       private void SetValueInColumnFooter(string UniqueColumnName,decimal TotalValue)
       {
           System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("en-us");
          
           System.Windows.Controls.UIElementCollection ElementCollectn = ((System.Windows.Controls.Panel)(this.radGridView.Columns[UniqueColumnName].Footer)).Children;
           UIElement[] ElementArr = ElementCollectn.ToArray();
           ((System.Windows.Controls.TextBlock)(ElementArr[0])).Text = "Sum (In USD) : " + TotalValue.ToString("C", ci);
      
       }

    }

}

 



0
Vlad
Telerik team
answered on 12 Aug 2010, 06:18 AM
Hello,

 Unfortunately it will be impossible to replicate the issue using your pasted code. Please open support ticket and send us small running example where we can reproduce and debug this.

Kind regards,
Vlad
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Satrajit
Top achievements
Rank 1
answered on 18 Aug 2010, 08:11 AM
Hello,

I had already created a support ticket for this with Support ID : 338291. 

Can you please let me know if an update on this is available?  

Thanks.
0
Milan
Telerik team
answered on 18 Aug 2010, 08:46 AM
Hi Satrajit,

We are currently looking into this issue. Thank you for your patience. 


Best wishes,
Milan
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
GridView
Asked by
Satrajit
Top achievements
Rank 1
Answers by
Maya
Telerik team
Satrajit
Top achievements
Rank 1
Vlad
Telerik team
Milan
Telerik team
Share this question
or