The AVG function returns the average value of all numbers in the set (e.g., Salary paid). Null values are ignored.
SELECT AVG(…) SELECT AVG(fact)
The metric AVG of Payment is computed by adding all payment transactions together and dividing by the number of payment transactions:
SELECT AVG(Payment) SELECT AVG(metric that uses fact)