Sales Amount is defined just as Subtotal Amount. How do I change that to reflect Taxes and discounts?
Using the Define Formula dialog, change the formulas for Sales Amount in the tables the field is defined. Remember to Refresh Formula again. 8. Can the queries that are standard with a DataHabitat product be selectively locked out, in order to limit user options? Can we define custom queries and then lock out some or all of the standard queries? If so, how? Yes, this is possible. You can define a user profile that will “see” only some queries (this also works for reports, tables, etc.). Then you will Define Users for each profile. If you define a query as “dba” (user login), only “dba” can change this query. For example, if you log in as “browser” and try to save a query created by dba, you will have to save it under another name.