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
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.