Computations can be performed by your database server or by Interactive Reporting on your desktop. A computation does not add data to the database; instead, new data items are added or data items are recalculated in your data set.
Interactive Reporting provides different tools for computing data items. These tools allow you to:
Examples of computed items include:
A Full_Name item that concatenates the values in the First_Name and Last_Name items.
A Profit item derived by subtracting the Cost of Goods column from the Gross Revenues column.
A Grade item that uses if…else logic to assign letter grades derived from test scores.
A Moving Average item that smooths a set of data points, i.e., removes irregular fluctuations in the general trend of data.