Here is a tough one. I have some data that is going into a datagrid via DATASETS. I need to Grab 3 totals.
The final total I already have using this code.
If DsOtherInc1.tblotherinc.Rows.Count > 0 Then
x = dgotherinc.DataSource.compute("SUM([Brw Amount])", 1 = 1)
txtTTLOthInc.Text = x
The other 2 totals are based off a different colum.
If colum "B" = Include Sum Column "C" of Includes only
If colum "B" = Exclude Sum Column "C" of Excludes only.
Example of what I am trying to say.
A b c
File1 Include 10.00
File2 Include 20.00
File3 Exclude 10.00
Total 1 = 40.00
Total Include = 30.00
Total Exclude = 10.00