General discussion

With version 12.4 of IDEA Caseware has created a template in which you can develop your scripts in VSCode which is extremely powerful.  I have create a video to get you up and running.

https://youtu.be/sRlTVNPZAW0

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

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!

Greetings, where can I get the date functions #cwi_1stOfNextMonth(), so I can download them all and install them?

Hello,
Some of my IDEA files were saved with IMD extensions but when I installed IDEA 12.3 version, I cannot open these files.  Instead, I keep getting the message that IDEA can open IDM files only.  Is there anyway to open up the old files with IMD?
Thanks,
Samy 

Hi everyone, just to let you know there is a site called Auditopia where they have lots of free training in data analytics.  Also the site is undergoing changes and until Feb 22, 2024 you can join the groups for free, one of them is on IDEA, after that date the groups will only be for pro members, I would suggest you check it out.

https://auditopia.com/groups-list/

Hi Brian,
I hope this message finds you well. I am reaching out to seek assistance in sorting the columns of my table based on our fiscal year, which runs from April to March. The table may include only a subset of months, for example, from April to August.
I am wondering if there is a more efficient way to achieve this rather than manually sorting the columns. I attempted to use an "if" function, but I encountered difficulties in implementing it successfully.
Ideally, I would like to extract the data with logic similar to the following:
 
 

I was using IDEA and running some scripts, suddenly I encountered the attach pop up.
I have check that the system anti virus is not blocking the software.
How can I solve this issue?

When applying criteria IDEA freezes at 0% with any file.  I imported a tiny 3 row, 2 field test file.  I set a criteria and it worked ok.  Then if you close and reopen the file it just sits at 0%.  IDEA is being run from a local drive (not network) and i have full permissions on the location. Any ideas?

Hi!
I'm looking for a script that would append additional column into my ile with values equal to source file name.
In my example I have text files e.g.  20230831.txt with one column of data.
I would like to import this file into IDEA and have to column of which one would store in every field value "20230831".
If there would be a way to import multiple file this way at the same time that would be excelent! :)
 
Thanks in advance for the help!
Regards,
Maciej