Forum Discussion
Average Invoice Value
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"I dont think I can add a calcuation at the report level?"
I don't understand what you are saying here. You only want at a grand total line? How are the other two columns calculated? As measures or calculated columns?
Matt,
On the report I want to add a column to the right that has the average invoice value for each customer. So as an example complete pool and spa part supply would have the value of 134.80 divided by the 3 invoices that created that gross Revenue. In an excel summary I would just add that column to the sheet. I would think you could add a column in the visualization table where that value could be calculated.
