|
Sum: for example, Sum(Salary, 1000, Bonus)
|
|
Avg: arithmetic average, for example, Avg(BudgQtr1, BudgQtr2, BudgQtr3)
|
|
Min: select the minimum value, for example Min(IQ, 125)
|
|
Max: select the maximum value, for example Max(Sale1, Sale2, Sale3, Sale4)
|
|
Salary: an integer or money attribute
|
|
Commission = Salary + (Bonus * 0.10)
|
|
Bonus = (Commission * 0.5) + 1000
|
Copyright IBM Corporation 2014. All Rights Reserved.
|