cancel
Showing results for 
Search instead for 
Did you mean: 

calculation

Former Member
0 Kudos
50

Hi Experts,

i am having two table A with no object and B with Object. there are three columns

Column 1 belongs to table A,

Column 2 belongs to table B,

Column 2 belongs to table B.

Now i want to multiply Column1 with Column 2 and store the resultant value in Column 3.

How can i do this....

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

edy_simon
Active Contributor
0 Kudos

Join them and calculate in query  ?

Former Member
0 Kudos

Solved...

Dim dss1 As SAPbobsCOM.Recordset

            dss1 = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

            dss1.DoQuery("SELECT T0.[U_FRPTOWay] as amt1 FROM [dbo].[@I8_LRM2]  T0 where T0.[U_Place]='" & oForm.Items.Item("31").Specific.Value & "'")

            Dim Col2 As SAPbouiCOM.EditText

            Dim ColVal As String

            Col2 = oForm.Items.Item("1081").Specific

            ColVal = Col2.Value

            oForm.Items.Item("55").Specific.Value = (dss1.Fields.Item("amt1").Value) * ColVal

Thanks

Former Member
0 Kudos

Hi

Try This.....

omatrix.Columns.Item("thirdcolumnid").Cells.Item(pVal.Row).Specific.value

= CDbl(omatrix.Columns.Item("firstcolumnid").Cells.Item(pVal.Row).Specific.value)  *

CDbl(omatrix.Columns.Item("secondcolumnid").Cells.Item(pVal.Row).Specific.value)

Thanks

Shafi