Excel formula program
Hi, I’m trying to do a table where I need to calculate how much commission I’m paying for a company. Before 35,000, I pay 35% commission after 35000 I pay 10%. The formula I have right now is =(IF(F9>=35,F2:F8*0.1,(IF($F$9<=35,F2:F8*0.35)))) and it works, but… I don’t want the whole column to change to 10% because I [...]
Answer Question
| February 25, 2013 1:59 AM
Microsoft Excel 2007, Microsoft Excel formulas
Hi, I’m trying to do a table where I need to calculate how much commission I’m paying for a company. Before 35,000, I pay 35% commission after 35000 I pay 10%. The formula I have right now is =(IF(F9>=35,F2:F8*0.1,(IF($F$9<=35,F2:F8*0.35)))) and it works, but… I don’t want the whole column to change to 10% because I [...]
Answer Question
| February 25, 2013 1:59 AM
Microsoft Excel 2007, Microsoft Excel formulas
Why limit CLI access on AS/400?
A little background… I am new to the compliance and auditing field and recently introduced to the AS/400 system and I am constantly seeing in best practice environments that the CLI be restricted from most users and or at least limited capabilities set to *YES. To the point… The system administrator for the AS400 is [...]
Answer Question
| February 25, 2013 12:13 AM
AS/400, AS/400 - CL Command, AS/400 security
A little background… I am new to the compliance and auditing field and recently introduced to the AS/400 system and I am constantly seeing in best practice environments that the CLI be restricted from most users and or at least limited capabilities set to *YES. To the point… The system administrator for the AS400 is [...]
Answer Question
| February 25, 2013 12:13 AM
AS/400, AS/400 - CL Command, AS/400 security
Window keyword in display file
I have a program that displays a list of items and when one is selected it pops a window with detailed information. When I select an item, my window will not display. Is there a configuration/setting somewhere on the AS/400 that would keep the window from displaying ?
Answer Question
| February 25, 2013 10:18 PM
AS/400, AS/400 Display File
I have a program that displays a list of items and when one is selected it pops a window with detailed information. When I select an item, my window will not display. Is there a configuration/setting somewhere on the AS/400 that would keep the window from displaying ?
Answer Question
| February 25, 2013 10:18 PM
AS/400, AS/400 Display File
IT help desk first come first serve
Why is it good or bad to operate an IT support services system (help desk) on a strictly, first-come, first-served basis?
Answer Question
| February 22, 2013 9:17 PM
IT Help Desk, IT support
Why is it good or bad to operate an IT support services system (help desk) on a strictly, first-come, first-served basis?
Answer Question
| February 22, 2013 9:17 PM
IT Help Desk, IT support
RPGLE SETLL / READE for update getting record lock on different key
We are encountering sporadic unexpected record locks with update files using: setll (Key1) MasterFile; // Partial key. dou %eof(MasterFile); reade (Key1) MasterFile; if not %eof(MasterFile); // [Stuff] update MasterFmt; endif; enddo; Looking at the problem record by RRN, its key does not match Key1. It’s not even the next sequential key value in the file. [...]
Answer Question
| February 22, 2013 8:59 PM
READE, Record lock, RPGLE
We are encountering sporadic unexpected record locks with update files using: setll (Key1) MasterFile; // Partial key. dou %eof(MasterFile); reade (Key1) MasterFile; if not %eof(MasterFile); // [Stuff] update MasterFmt; endif; enddo; Looking at the problem record by RRN, its key does not match Key1. It’s not even the next sequential key value in the file. [...]
Answer Question
| February 22, 2013 8:59 PM
READE, Record lock, RPGLE
One user, multiple email domains, unique sent from addresses
Our mail server is aliased for several different email domains. Now we have a user who is taking on a role that will require him to receive emails from these different domains and then reply to them with “from” names that use that same domain name. For example, he may receive email at jimmy.freon@sunday.com and [...]
Answer Question
| February 25, 2013 7:00 PM
Lotus Domino 8.5.3, Multiple Mail Domains
Our mail server is aliased for several different email domains. Now we have a user who is taking on a role that will require him to receive emails from these different domains and then reply to them with “from” names that use that same domain name. For example, he may receive email at jimmy.freon@sunday.com and [...]
Answer Question
| February 25, 2013 7:00 PM
Lotus Domino 8.5.3, Multiple Mail Domains
Checkbox
In my application 5 checkbox and many times more than two checked box selected at a time so what code should I write that selected checkboxes save in database using VB.NET?
Answer Question
| February 22, 2013 6:58 PM
VB .NET, VB.NET checkbox
In my application 5 checkbox and many times more than two checked box selected at a time so what code should I write that selected checkboxes save in database using VB.NET?
Answer Question
| February 22, 2013 6:58 PM
VB .NET, VB.NET checkbox
What big data trends do you see emerging in 2013?
With big data management becoming a critical priority for enterprises, it’s important for them to stay on top of the latest trends. ServerSide.com believes the trends this year will include: A rise in cloud storage, organization of unstructured data and the importance of real-time analytics. Do you agree with these trends? What big data trends [...]
Answer Question
| March 5, 2013 6:27 PM
Analytics, Big Data
With big data management becoming a critical priority for enterprises, it’s important for them to stay on top of the latest trends. ServerSide.com believes the trends this year will include: A rise in cloud storage, organization of unstructured data and the importance of real-time analytics. Do you agree with these trends? What big data trends [...]
Answer Question
| March 5, 2013 6:27 PM
Analytics, Big Data
Flagged emails automatically going to tasks
Why do flagged emails automatically go to the tasks?
Answer Question
| February 22, 2013 4:57 PM
Email, Email administration
Why do flagged emails automatically go to the tasks?
Answer Question
| February 22, 2013 4:57 PM
Email, Email administration
AS/400 Query – how do you split names in field into seperate fields
Trying to separate a field into three separate fields. The field is a name field, with lastname firstname mi with spaces in between each name. Is there a way to do this? I’ve tried everything I can think of, am out of ideas. Thanks in advance for your help
Answer Question
| February 22, 2013 3:56 PM
AS/400, AS/400 Query, iSeries
Trying to separate a field into three separate fields. The field is a name field, with lastname firstname mi with spaces in between each name. Is there a way to do this? I’ve tried everything I can think of, am out of ideas. Thanks in advance for your help
Answer Question
| February 22, 2013 3:56 PM
AS/400, AS/400 Query, iSeries
Which should I do: SAP ABAP or BI?
I am certified in SAP ABAP and I got the job in SAP BI/BW. What should I do? Please help me soon.
Answer Question
| February 22, 2013 3:22 PM
SAP ABAP, SAP BI
I am certified in SAP ABAP and I got the job in SAP BI/BW. What should I do? Please help me soon.
Answer Question
| February 22, 2013 3:22 PM
SAP ABAP, SAP BI
Domino Upgradation 7.0 to 8.5.3
Hi , We are planning to upgrade the Domino server from 7.0 to 8.5.3 Can you tell the right procedure please?
Answer Question
| February 22, 2013 12:41 PM
Lotus Domino 8.5.3, Lotus Domino server
Hi , We are planning to upgrade the Domino server from 7.0 to 8.5.3 Can you tell the right procedure please?
Answer Question
| February 22, 2013 12:41 PM
Lotus Domino 8.5.3, Lotus Domino server
How to display total of all the records that contain the same primary key in RPG4?
How to display total of all the records that contain the same primary key in RPG4? e.g… Transaction number :4458 product no: name [...]
Answer Question
| February 22, 2013 11:17 AM
RPG, RPG Code
How to display total of all the records that contain the same primary key in RPG4? e.g… Transaction number :4458 product no: name [...]
Answer Question
| February 22, 2013 11:17 AM
RPG, RPG Code
Data migration from AS/400 DB2 to SQL Server
Any cheap and best tools available for data migration from AS/400 DB2 to SQL Server?
Answer Question
| February 22, 2013 6:56 AM
AS/400, SQL Server
Any cheap and best tools available for data migration from AS/400 DB2 to SQL Server?
Answer Question
| February 22, 2013 6:56 AM
AS/400, SQL Server
Office 2007 & Windows 8
Will MS Office 2007 ultimate run under Windows 8?
Answer Question
| February 22, 2013 6:01 AM
Microsoft Office 2007, Windows 8
Will MS Office 2007 ultimate run under Windows 8?
Answer Question
| February 22, 2013 6:01 AM
Microsoft Office 2007, Windows 8
How to find the copybook?
Hi, I need to make few changes to a copybook in COBOL/400. I know the name of the copybook. Please let me know how to locate it? Regards, M
Answer Question
| February 22, 2013 4:05 AM
AS/400, COBOL/400
Hi, I need to make few changes to a copybook in COBOL/400. I know the name of the copybook. Please let me know how to locate it? Regards, M
Answer Question
| February 22, 2013 4:05 AM
AS/400, COBOL/400
Can you do full system restore twice ie option 21 on go restore menu
Hello, We have a new power 7 machine migrating from a power 6, we are using option 21 to save entire system, then option 21 on the restore menu to restore entire system to the new system. The first restore will be a test. When we go live, the plan is to do the same [...]
Answer Question
| February 22, 2013 2:59 AM
Power 6 machine, Power 7 machine
Hello, We have a new power 7 machine migrating from a power 6, we are using option 21 to save entire system, then option 21 on the restore menu to restore entire system to the new system. The first restore will be a test. When we go live, the plan is to do the same [...]
Answer Question
| February 22, 2013 2:59 AM
Power 6 machine, Power 7 machine
2 iPhones
I have two iPhones 1 personal and 1 work. I want Skype on both. Do I have two download from two different computers? Can I use the same account?
Answer Question
| February 22, 2013 10:48 PM
iPhone, Mobile
I have two iPhones 1 personal and 1 work. I want Skype on both. Do I have two download from two different computers? Can I use the same account?
Answer Question
| February 22, 2013 10:48 PM
iPhone, Mobile
Are you familiar with identity management systems?
As BYOD becomes more prevalent, some companies have turned to identity management systems to safeguard data and employees. Are you aware of identity management systems? Has your company adopted such software tools?
Answer Question
| March 5, 2013 8:08 PM
BYOD, Identity management, Security
As BYOD becomes more prevalent, some companies have turned to identity management systems to safeguard data and employees. Are you aware of identity management systems? Has your company adopted such software tools?
Answer Question
| March 5, 2013 8:08 PM
BYOD, Identity management, Security
