I need to generate a report based on Ubercart purchases that involves some math and some complex queries. Can Views do that? The Views 3 docs don't seem to exist, yet, and I want to find out if Views are the right approach before I'm up to my neck in them.
Can Views sum up the results of a query to get one number, then report that number?
Can it apply a mathematical formula to that number?
Can Views handle very complicated queries where it checks multiple tables to extract and process the right result?
Can Views execute custom PHP code to get information? Is that a good idea?