Forum Discussion

sam_nik12345's avatar
sam_nik12345
Helper II
4 years ago
Solved

create new column multiplying values from other table

How can a create a new column by multiplying values from other column. My tables look like below. How do I get reqd column? Kindly help.     month value qty reqd jan 2 1 value * qty ...
  • amitchandak's avatar
    4 years ago

    sam_nik12345 ,

     

    new column

     

    reqd = [value] *[Qty]

    reqd = sumx(Table,[value] *[Qty])