IDEAScript Questions

Hello -
I am new to IDEA, and was hoping someone could assist me.  I have files in a similar format as below.  What I need to do is take the median of Amt1 - Amt5 for each value in the Text column.  I created the median field using the excel function and was hoping I would be able to do the same in IDEA.
I've been able to compute the median for individual columns, but have not yet figured out a way to do it across a row.
Thank you in advance.
 

Hi Brian,
I am implementing CaseWare Monitor and that will be used to run my scripts and manage the subsequent exceptions. To do this, I can't have any message boxes pop up through the script, including error messages, as CaseWare Monitor will just hang waiting for the user to press OK.

Does anybody have an IDEAscript to run a macro?

Hello-

I have a long list on transactions and a pdf copy of an invoice for each on my computer.  
Is there  way for me to define an action field such that I can click on the document number field in IDEA, and automatically open the correct document on my computer?
The helpdesk said it is possible using a script, but I haven't had much luck.   
Thanks,
Will

Hello,
Can we have a way to add variables to editable fields?
I have a database with a editable numeric field and i want to add to a certain field my record counts from other databases.
My idea is the version 9.1.1.152
Thanks
Rodrigo

Hi There,

Hi all,
I am trying to put together a script that lets me run a selected check on based on the appropriate VAT category by using radiobuttons. I tried basing the script on the one in the instructional video on this site, though i'm stuck at the radio buttons.

Hi all,
I want to create a script where users can select multiple fields and for example delete them.
I found the right snippet (Using listboxs to select files/fields) but don't know how to change the script to read the fields instead of the files and perform a task on the selected fields.
thx :)

I have created a script that runs around various files and generates stats from the files. Right now it is writing the results to an array. Is there a way to have the array output into a new IMD file? Or would it be best to write to an excel file?
 
Thanks