I have a data table with several values, I need to take the value of the column “Amount” when the column “Denomination” is Equal to the cell “Selling Price”, the values can be in different cells.
So far I have this
ExtraccionTablaPrecios.Select(“Denominación=‘Precio de Venta’”)
But I need to obtain the value of the cell corresponding to the column “Amount” according to this criterion.
Please try this in assign
This will store in a datatable
= dtTable.select(“Denomination = ‘Selling Price’”).copytodatatable
And for fetching 1st row value use
But the problem is that the value is not always in the first row.
it have multiple selling price or only one will come?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.