And what do you suppose all those asterisks before many of the Excel
function names mean? Same as Excel function support under MDX? (What'll
be next, XMD or XDM?) If so, that means they're NOT SUPPORTED. So, if I
needed LinEst or MMult, I'd continue using Excel. You'd do something
different in no small part because you have no clue what these
functions do.
That's the problem with militant ignorance like yours - it's so stupid
it believes it's a virtue.
Maybe nothing in the database world stumps you because no one tries to
do anything particularly complex numerically in the database world. The
fact that Excel's more advanced numeric functions aren't in the
database world tends to support the case that there are some things
databases can't do.
the basic math that you do in excel deserves to be in a database
Everything can be boiled down to 4 operator arithmetic, but (1) it's
grossly inefficient to do so, and (2) you'd have no clue how to
represent even exponentiation to fractional powers or logarithms using
just +, -, *, /. Since queries and subqueries are the only way to
render mathematical expressions in SQL, you're correct in theory, but
as usual your database suggestions would be so inefficient that no one
other than you would try to follow them.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
