i have a workbook that shows all customers assigned to a sales person and the total number of sales orders - including 0 orders. I also need to add the total revenue for those customers - including the 0 sales customers but am not finding the right field to do this. Is there a field in the customer table that gives total revenue?

One way add a sum of formula (currency) DECODE({transaction.type},'Invoice',{transaction.amount},0) You could then decide if you want to be summing Sales Orders or {amountnet} etc. If you just do a regular join' via the selection dropdowns then that will be excluding any customers without transaction records.