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...
I have the provided sample data. I select customer number, then data field " Sum of Price" bad name for a data field and let BI summarize the values for all transactions for each customer number. Then I select Invoice number and ask for distinct count to get the number of invoices. Hope this helps explain the situation.
https://ebsbi.sharefile.com/d-sae5c5584a564dc8b
Regards,
Scott