General discussion

Hi,
I need to do a calcul to get a result in percentage % , so is there any function or script to do it ?
as alternative solution what I'm doing is : creating new numeric field and I insert this fomule : (Column A / Column B )*100  
Thank you.

Hi;
I've a database that I need to compare between the line 1 and the line 2 ...e, 
for example :  
In this case; i need to get the difference between the start call of line 2 with the end call of line 1  and 
 Thank you.

START CALL
DURATION
Duration_HOURS 
End_Call

17:26:18
139
00:02:19
17:28:37

17:28:50
60
00:01:00
17:29:50

17:29:52
45
00:00:45
17:30:37

Hello everybody,
I am having difficulty in appending multiple sheets importing from excel. Why i tried to join these sheet together, the system notify me about the field format is different. Is there a way or any tips to mass formatting multiples sheets at one? Since having 50+ sheets to append might be time consuming.
Thank you very much,
Best regards,
Trung Nguyen

Hi All,
I need to deal with a field ( numeric type) containing a number called duration with this format for example : 14100 wich mean that the duration is 101 second, another exmaple :
1333800 = 5618 second
1410100=6061 second
So which function ca help me to get the result in second ?
Thank you.

Hi All,
Can you help or guid me to extract without duplicated data  ? 
column A (character type ):
1  
2
1
4
5
1
3
Thanks.

Hi All,
I have a field that contains a list of number separated by (,), what i need is : create a lot of field depended of how number contained in it ,
for ex : 3554249, 3554250, 3554251, 3554252  and the result that i'd like is for ex :

A
B
C
D

3554249
3554250
3554251
3554252

Thank you.

Hello,
 
How many different kinds of IDEA license are there?
- Client Version
- Server Version
- Single User Version
- Shared User Version
 
I am purchasing new laptops to run IDEA on standalone mode (Client Version).
What is the recommended laptop specification?
 
Thanks and Regards!

Hello,
 
I am using IDEA by extending my desktop across my laptop screen and another big monitor.
 
But when I am using IDEA in my laptop, I realise that some windows in IDEA will be missing / out of sight. 
 
Is this an existing problem with IDEA? If yes, are there any resolutions for this?
 
Thanks and Regards!

Hello,
 
I had joined a primary database to a secondary database using "Records with no secondary match" option where both databases have a common key.
 
After looking through the data in the joined database, I realised that some of these unmatched data to secondary database were found in secondary database.
 
So I re-joined the joined database to the same secondary database using "Records with no secondary match" option. And the output database had fewer records compared to the first join.
 

I have been trying to use this date type var in a dialog box but it is giving me an error
 
Dim StartDate, EndDate As Date
 
Sub Main
StartDate = dlgEnable.TextBox2
EndDate = dlgEnable.TextBox3
Call DirectMCINTExtraction()                
End sub
Function DirectMCINTExtraction
Set db = Client.OpenDatabase(InputFile)
Set task = db.Extraction
task.IncludeAllFields
dbName = FileName +"_INTL.IMD"