Databases Reference
In-Depth Information
2.
Enter the formula as shown below in the formula editor. The formula states
that the member
TOTAL NET REVENUE
is calculated as
GROSS REVENUE
less
DISCOUNTS
"TOTAL NET REVENUE"="GROSS REVENUE" - "TOTAL DISCOUNTS";
The member
TOTAL NET REVENUE
is tagged as
Dynamic Calc
. When a
database user executes a retrieve for the data stored in the
TOTAL NET
REVENUE
member, the
TOTAL NET REVENUE
value will be dynamically
calculated as
TOTAL NET REVENUE = TOTAL REVENUE - TOTAL DISCOUNTS
.
3.
As shown below in the
Formula
editor screen, once you have entered
the formula, you can click on
Verify
to verify it and then click on
OK
to
save the formula. It should be pointed out that the formula is only saved
in a temporary buffer until the database outline has been saved.