General discussion

I'm wondering if it's possible to use IDEA (v 10.4) to either prove or disprove a theory.  The theory is that training (online and classroom) improves turnover.  I have access to all the tables in the HR database which has the training area.  I pull termination dates and course completion dates but that is not enough to prove causation.  Has anyone done anything along these lines, maybe marketing/sales?

Good afternoon,
Does anyone have a crafty way to compare  multiple numeric fields (More than 2, I would otherwise use the @MAX function) in a database. I would like to take the highest numeric value and then do some testing on that... Thanks for any insight!

I have over 5000 time entries and I'm trying to check for overlaps on the same dates. I've tried using a date overlap script that I saw on here, but I cannot get it to work for the time. 
 
That data looks like this:

DATE
FIRST TIME IN
FIRST TIME OUT

2015/12/07
16:15:00
18:15:00

2015/12/07
19:00:00
21:00:00

2015/12/10
07:30:00
09:30:00

2015/12/10
12:30:00
14:30:00

2015/12/10
14:45:00
16:45:00

I'm working with a ton of medical claims data. I took claim data from 23 different offices and appened everything together. Then I ran the duplicate key using the recipients ID # (each patient's is unique) and the date of service. The result is 1.8 million duplicate claims. Also, each office has it's own unique billing number. From the duplicate results, they want me to take a specific office and find just the duplicates conencted to it. 

Hi Brain,
Is it possible to move a file inside to '+' as in the attached screenshot?
My child file is not grouped inside the + during the execution. is it possible to move it by code.
 
 

Hello,
I am Alice, I'm new in this forum and on IDEA.
I'm looking for some script/function whitch could : analyse a list with different parameters, and would be able to detect any duplication (perfect duplication on each paramater OR duplication for few parameters) . The result would be : the list with 1 item.
 
EXAMPLE:
my list :
NAME / COUNTRY / AGE
1 - Alice   - France - 30
2 - Paul - Canada - 30
3 - Alice - France - 30
4 - Alice - Spain - 20
RESULT 1 : detect perfect duplication =>

Hi,
I am testing for the risk of employees not recording Annual Leave appropriately. I have 3 sets of data, ie Employee Leave Taken, Network Access and Building Access listing. I cannot get my head around how I can identify instances on an ordinary working day have not access the network or building. The assumption in this scenario is that if the employee is working, they would have accessed both. Of course, there will be some explained reasons.
 
Have any of you performed such test? I am curious to hear how you performed it in IDEA. Thanks.

Hi Brian,
For my project, I want to show a dialog during the execution of the routine.
I filled value to dropdown and everything as my need. 
I want to erase the text box value after an add button is clicked.
But it was not deleting the value.
DlgListBoxArray  "TextBox1", "" 
I tried with the above code. Do you have any suggestions to clear the value in textbox.
Thanks In advance
 
 

Hi Brain,
I have dynamically created a new file and created its column and filled calculated values in the column too. But my issue is that while creating the column, I have created as a WI_NUM_FIELD. But in the result column, it's showing as an editable numeric column. 
Do you know what is the issue? 
While creating the column I have changed the property NewTable. Protect = False, After that set NewTable.Protect = True

Hi,
Has anyone used Benford? I was asked to try and use the Benford on IDEA but I have no idea what parameters I should enter!
Any tips? Thanks!!