General discussion
Help with Formula
Forums
I need some assistaance with creating a script. Im trying to take the formula below and replace it with variables based off an input box. i can get the code to run seperately but when i add the "or" it throws it off. Any help would be appreciated.
task.AddExtraction dbName, "", " CREDIT >= ( 1000000 ) .OR. DEBIT >= ( 1000000)"
i have the following but am getting errors
task.AddExtraction dbName, "", debit & " >= " & amount & .or. credit & " >= " & amount
- Read more about Help with Formula
- 3 comments
- Log in or register to post comments
summarization /Use fields from Last occurrence
Forums
Hi,
How's it possible to do summarization for a column containing a number (numeric field ) and to give it as reference the field date when I select "use fields from last occurence" ?
Thank you,
Ahmed.
Rename multiple Idea Files
Forums
Hi there.
- Read more about Rename multiple Idea Files
- 7 comments
- Log in or register to post comments
CaseWare Cloud Analytics
Forums
Looks like CaseWare Analytics is going into the Cloud. Check out this video to learn more.
- Read more about CaseWare Cloud Analytics
- Log in or register to post comments
Concatenate to a single record
Forums
Goodmorning my fellow IDEA users,
I'm having a relatively simple problem (i think) but it is driving me crazy:
I'm trying figure out if it is possible to refer to a single record in the Equation Editor like it is possible in Excel with prefix $ in a cell?
Thanks in advance
Dino
- Read more about Concatenate to a single record
- 3 comments
- Log in or register to post comments
New Video on creating an IDEAScript
Forums
I just posted a new video on creating an IDEAScript from start to finish with a dialog. It shows you what I think is the best way to put one together.
You can find the video here or on YouTube.
http://ideascripting.com/video/basic-ideascript-video-start-finish
- Read more about New Video on creating an IDEAScript
- Log in or register to post comments
Function Soundlike
Forums
Hi,
Pleas I need Help on one equation on Idea and this is my problem :
I got two files having column of the person’s name and I want to check with the function @SoundsLike the existing and no existing name on each file
How can I do this pleas
- Read more about Function Soundlike
- 3 comments
- Log in or register to post comments
10.3 is now available
Forums
You can read what is new in 10.3 here (https://www.casewareanalytics.com/blog/what%E2%80%99s-new-idea-103)
The big thing for this web site is that IDEASCripting now allows scripts to be created in Python. So I will be adding on Python resources as I have time.
- Read more about 10.3 is now available
- Log in or register to post comments
Smart Analyzer
Forums
Hi Brian,
I have two queries.
1. I just wanted to know if is it possible to find the script or logic behind smart analyzer app.
2. How do i build a app which can be shared and used in smart analyzer of other users or is it possible only through marketplace?
Regards
Padma
- Read more about Smart Analyzer
- 1 comment
- Log in or register to post comments
Now on twitter
Forums
I have finally moved into the 21st century and created a twitter account. I will be tweeting when I add new stuff to the site or things I find interesting to the IDEA users. You can follow me at https://twitter.com/ideascripting.
- Read more about Now on twitter
- Log in or register to post comments