General discussion
Visual Studio Code now can be used to develop IDEAScript
Forums
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.
General Guidance On Sampling
Forums
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
- Read more about General Guidance On Sampling
- 1 comment
- Log in or register to post comments
Report Export
Forums
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!
- Read more about Report Export
- 2 comments
- Log in or register to post comments
Funciones de fechas
Forums
Greetings, where can I get the date functions #cwi_1stOfNextMonth(), so I can download them all and install them?
- Read more about Funciones de fechas
- 2 comments
- Log in or register to post comments
How to open IMD files on IDEA 12.3 version
Forums
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
- Read more about How to open IMD files on IDEA 12.3 version
- 2 comments
- Log in or register to post comments
Auditopia
Forums
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.
- Read more about Auditopia
- Log in or register to post comments
Sorting Table Columns Based on Fiscal Year
Forums
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:
- Read more about Sorting Table Columns Based on Fiscal Year
- 6 comments
- Log in or register to post comments
System Clock Changed
Forums
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?
- Read more about System Clock Changed
- 1 comment
- Log in or register to post comments
IDEA freezing (not multi monitor issue)
Forums
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?
- Read more about IDEA freezing (not multi monitor issue)
- 1 comment
- Log in or register to post comments
Append file name as value in column
Forums
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
- Read more about Append file name as value in column
- 2 comments
- Log in or register to post comments