Questions on IDEA Analysis

Is there a way to perform a test using IDEA that would pull recurring monthly, quarterly, semi-annually expenses from a general ledger? Thanks!

I am new to this forum and to IDEA, so I apologize if this has been discussed before or is fairly easy to do, but I am trying to do a direct extraction of any records that have a date field that does not equal the last day of the previous month (i.e. if I run the extraction today on 11/17/2022, I want all records where the date field is not 10/31/2022).  I am trying to write the formula in a way that I will be able to automate the extraction going forward with a script.  Any help would be appreciated.

Hi, 
I am trying to create a computed field as follows.

Hi Brian,
IDEA SmartAnalyzer is working.
I run "summary by account combinations" in idea for all accounts, I get the attached error.
 
Can you help me please
 There is 600 GB of free space on the disk where the project is located.
Thanks

Hi Brian,
IDEA analysis is very slow. What are your suggestions to speed it up?
I am running on high performance server but still very slow.
I'm working with 165 million records
 
Thanks

Hi there,
I am relatively new to using IDEA for analysis, and I've been trying to figure out this testing, but I'm not sure if I'm just missing an obvious solution, or maybe there's another way to do this testing. 
I am analyzing travel expenses and I want to identify and extract entries where every other field is the same (i.e. report key, expense type, travel start date, travel end date, transaction date, etc.) EXCEPT for the expense amount fields.
Basically, I'd like to identify and extract records where the two following scenarios occur:

Hi.  Is it possible to rank numeric results similar to the rank function in excel e.g
 55,767,767,825 would be 1,2,2,3.

I'm trying to detect if I have in my ERP database vendor master file (Great Plains) employee names that reside in a different database (Vista/PDS).  I tried joining the two on address ID but that didn't work very well.  Is there another way to do something like this?

Hello all,
 
I wondered if anyone came accross any of the 2 situations below:
 
- situation 1:  IDEA crashes after performing all of the functions within the code - all of the tests are complete - the last line of code is displaying the message and then round circle is coming up on the screen and IDEA shuts down (just the database file - the code module remains open)
 

Hello all,
Below is one of the table that i use in my analysis.The table contain some unique reference number in first column and some additional reference data in column 2.