J
John Gilchrist
I have used the TOOLS --> SUBTOTALS feature to display a TOTALS subtotal
line in sales data (total qty, extended cost, extended sale price, etc).
However, I wish to display a function which is a combination of the other
totals on the same line.
TOTAL_MARGIN = (SELL - COST) / SELL * 100
I don't want this TOTAL_MARGIN to be displayed on each line-item - only on
the TOTALS line.
I would like to create a template, to automate the process of creating thie
TOTALS line with the TOTAL_MARGIN value for non-technical users.
thank you,
John
line in sales data (total qty, extended cost, extended sale price, etc).
However, I wish to display a function which is a combination of the other
totals on the same line.
TOTAL_MARGIN = (SELL - COST) / SELL * 100
I don't want this TOTAL_MARGIN to be displayed on each line-item - only on
the TOTALS line.
I would like to create a template, to automate the process of creating thie
TOTALS line with the TOTAL_MARGIN value for non-technical users.
thank you,
John