Caseware idea unable to open database
![caseware idea unable to open database caseware idea unable to open database](https://i.ytimg.com/vi/1I0c6NpCE9w/maxresdefault.jpg)
If there is an error, the message box will indicate either a type error or syntax error. If your equation is correct, you’ll get a message indicating that it is indeed a valid equation. You can use the Equation Editor to validate your equation by clicking the Validate button. In order for IDEA to run the extraction, your equation must be valid.
![caseware idea unable to open database caseware idea unable to open database](http://ideascripting.com/sites/default/files/filldown3.jpg)
You don’t need to add currency indicators, or thousand separators here, just put in the number. Then enter the value you are comparing your data to. Next, you either type or select the comparison indicator: Greater Than. Click enter to have IDEA fill in the value for you. As I type a list of potential fields is displayed. To generate that equation, you can either start by typing “credit limit” in the equation box, or you can scroll through the Field list and double click it. Remember, I’m looking for Customers who have a credit limit of 30,000 dollars or greater than can be expressed by this equation. The Equation Editor is launched by the button between File Name and Criteria that looks a little like a calculator. If you know the exact equation you need to get the filtered records you can go ahead and type it in. When you tab out of the name field you go to the Criteria field. You do that by clicking on the first row where it says Extraction1 and typing in a new name. Start by giving a name to your new database. This is the Direct Extraction dialog box. Next, click the Analysis tab and select Direct in the Extract group. To start, ensure Customer is the active file and Data is selected in the Properties window. For this example, I want to create a new database of Customers who have credit limits of 30,000 dollars or greater. This section will look at Direct Extraction.ĭirect Extraction involves entering a set of criteria or conditions and all records which meet those conditions are extracted to a new file. Random sampling, as we have seen, is one method of extracting data.