Home : Calc Data Block
Q10998 - INFO: Calc Data Block

The Calc Data Block feature provides a way to update selected equations over a specified time period.

 

         Variables can be selected using a Where Clause

USING:

Set the dates (see entering dates)

Choose the variables to be calculated using  and/or

Click

 

BUTTONS

Calculates the equations in the Variables to Calculate list box for the date range.  A progress window will be displayed during calculation.
Allows Variables to be added to the calc list through the Variable Browser.

Adds all calculated variables in the database to the list.
Removes selected variables from the calc List.
Removes all variables from the calc list
Adds the variables from the selected saved group into the Variables to Calculate list box.  A list of previously saved groups will be displayed for selection.

Saves the variables in the Variables to Calculate list box for future loading.  When [Save Group] is clicked, the Group Name Dialog appears.  Enter a unique group name and click [OK] to save the group.  [Cancel] takes you back to the Update Data Block form without saving the list  of variables as a group. A Where Clause that selects a group of variables can be saved as a group.  The where clause must be valid and return variables before it can be saved as a group.

Deletes a saved group from the list of groups (this does not remove the variables from the database). Click [DelGroup] to display the Select Group dialog.  Click on the name of the group to delete and click [OK]. 

Exits the form.

             Aids in adding content to the where clause.

              Tests the where clause.       

                                   


EXAMPLES:

 
Var 10 is a calculated variable.  It's equation is: V10 = V8 * 8.345

Var 8 is also calculated and its equation is:  V8 = V7/1000000

Var 7 is a parameter

If Var 10 is the only variable in the list of Variables to Calculate, only Var 10.  If Var 8 should also be updated, it also must be included in the list of Variables to Calculate.

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 4/25/2008 1:15 PM.
Last Modified on 6/25/2020 8:19 AM.
Last Modified by Steve Fifer.
Article has been viewed 5518 times.
Rated 6 out of 10 based on 3 votes.
Print Article
Email Article