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.
I think that mattbrice was suggesting that you add a new measure to do the calculation, then add that measure to the table.
For example:
1. Click Modeling > New Measure
2. Type the formula, e.g:
Average Invoice Value = DIVIDE ( [Sum of Price], [Count of Sales Invoice Number] )
3. Add that measure to the Values of your table
