Is there a way of filtering a table, when one of the columns contain text “discount”. There are many descriptions and the only distinct text is the word “discount”. I need a few of the columns in the table but only need rows where the one column contains “discount”
Starting point, is a table that list all invoices by line item, where one of those rows is the discount value.
I am trying to create a table, that list
- invoice number,
-invoice total and
Using this table, I can calculate the % of the discount to the invoice value. Discount/Total invoice. then I will place this % in the invoice detail to then get item - Discount . End result to gain true selling price for each line item on a invoice.