Skip to main content

General discussion

Search for tables

Hello,
I'm automating several IDEA scripts. It turns out that for my analyses, I always import two large tables. I've written a separate script to import those two tables. I scheduled the import in Windows to run early in the morning. The question is: How do I get the other scripts to search for the tables in that folder and load them when they run?
Thanks

Exclusion command in IDEA

I'm trying to get a table that doesn't have duplicate records, but I've been unable to do so by applying the IDEA Exclusion command. It's easy to do in Excel, but I haven't been able to do so in IDEA.

Is there a way to get this result in IDEA?
For Example
I want it to extract non-duplicate records.
...................................................................................Thanks, I already saw the command to get what I want

trying to extract using @GetNextValue

I'm trying to extract the next-closest accounts that have a Y or " " in the clc_titular field. I'm using @GetNextValue, but the formula throws an error in the equation.

I'm only interested in extracting the accounts that are related and... with the same account that is blank, as shown in the case.

And relationship

General Guidance On Sampling

General Guidance On Sampling

Hello everyone, I have a doubt. Does anyone knows about this material?
I would like to know about Sampling using IDEA. As you can see, it has a note: "To request a copy of this document, contact Caseware IDEA Support" How can I get it?

Regards

References
[1] Donald M. Roberts, Statistical Auditing, AICPA 1978

[2] William G. Cochran, Sampling Techniques; third edition, John Wiley & Sons, New York, 1977

Report Export

Hi Idea Community!
I have a problem regarding exporting reports to pdfs.
Sometimes when i want to export report to pdf IDEA starts the export and i see tens/hundrets of pages beeing generated in the pop up window. If i would leave it there it could generate the report infinitely. There should be one or two pages tops usually. This occures sometimes on my machine and then suddenly the issue disapears. Unfortunately this can happen on other machines in my organisation and the problem wouldnt go away.
Please help!