General discussion

hi,
I have a rookie question. I cannot seem to get my stratification to work. I have attached a screen shot of my setting and the error message. would anyone know what I am doing wrong?
Thanks!

My audit team is debating whether to use IDEA or the company-adopted Power BI as our primary analytics tool.  What does IDEA do that Power BI (or even open source tools like Python & R) doesn't?  
 
We actually have had IDEA for a few years without heavily utilizing it, so we do not believe we can provide an informed answer to this ourselves.  We considered asking an IDEA sales rep - would they share with us the unique features?
 
Thanks for your help!

Hello all,
Is there any quick method of getting the name of the month (using the Date field in the datasource) rather than writing a long formula with @if(@month(DATE) =1, "January" ... etc.
Regards
 

Hi,
I'm currently creating a script where by I am extracting some key statistics for individual locations for my company.  This information is then exported to an Excel Spreadsheet template populated with company norms (created by a separate macro) in order to provide a comparison. 
 

Hi,
I normally use vscript (macros) and I wanted to create a script to pick up the value on fields which are shaded in colour in Excel.
Background: I sent out a survey in Excel to a number of people. Response came back with various fields being shaded (eg Agree, Disagree, etc). These have values of 1-5 in them. However, I need to assess the value provided on each question as a whole, hence, having them shaded doesnt help.
This brought me to the question of: How can I use IDEA to identify the value in each of the questions that was shaded in colour?

Hi,
I'm searching to modify the data that is distributed into various columns into various lines to be able to manipulate and filter information. This is somehow and example of how the columns look:
Name / Last name / Data1 ID / Data1 BEGDATE / Data1 ENDDATE / Data2 ID / Data2 BEGDATE / Data2 ENDDATE / Data3 ID / Data3 BEGDATE / Data3 ENDDATE
And this is how I need them:
Name / Last name / Data1 ID / Data1 BEGDATE / Data1 ENDDATE
Name / Last name / Data2 ID/ Data2 BEGDATE / Data2 ENDDATE
Name / Last name/ Data3 ID/ Data3 BEGDATE / Data3 ENDDATE

Hello,
I am trying to figure out a way to do a 'text to column' type of task in IDEA instead of Excel. 
I want to be able to take a file that containst a listing of names that contain the first and last name in a single field and create a separate first name field and last name field.
I am hoping for an easy solution for this, it doesnt have to be a script. 
 
thanks! 

Hi,
What would u specify to filter for data with blank dates? I presume the @isblank function work as it is for character?

Hi,
I am very new to IDEA and I have had extensive knowledge in other softwares.
Would any of you know how to specific time range? The purporse of this is to search for transactions out of the normal business hours.
If you could let me know, that will be great. Thank you!
 
EL

Hi I am trying to put together a dialog window to accomplish the following:
Dropdown that allows the user to select any field from the active databse.
Each unique value from that field show up  allowing the user to check off values to be handeled differently later in the program.
 
Is this possible, if so, do you have any resources that could help me accomplish the task? I already have the dialog box built and working for the rest of the program, I am trying to add this on.
Thanks!