Forum Discussion
Solved
Average Invoice Value
Have a table that displays customer name, customers gross sale values for a filtered time period and the number of invoices relating to those sales. Want to add another column in the report that show...
Can you just divide the gross sales value measure by the number of invoice measure you already have?
Matt,
Dont think so. Using the BI functions to key off customer name, aggregate invoice value into total value, then using the count distinct function to determine qty of invoices. So I have all the pieces of the puzzle, but not familiar enough with the BI product. I dont think I can add a calcuation at the report level?
Scott