Calculation of metrics at database level or reporting level..? which is the best way..?

I just came across a same old situation of deciding where to do the calculation of certain metrics like percentages ? Here is my take on it with a fictitious example - Scenario 1:  Calculating it at database level and preserving it in the database: see Fig.:1(Associate Level Sales) showing a table with sales made by a few sales executives... Continue Reading →

Up ↑