Answer Posted / sridhar
The purpose of SV is to know whether the delivery is done on time or not. If not, what is the variance.
PED- Planned END Date
PSD- Planned START Date
ASD- Actual START Date
AED- Actual END Date
Formula:
=IF(OR(ASD="",AED=""),"",IF(AED=PED,0%,IF(AED>PED,((NETWORKDAYS(ASD,AED)-NETWORKDAYS(PSD,PED))/NETWORKDAYS(PSD,PED))%,0%)))
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
WHAT IS OBJECT REPOSITORY? AND IT TYPES? HOW MANY TYPES OF ACTIONS ARE THERE IN QTP? CAN WE ADD NEW OBJECTS AND PROPERTIES INTO SHARED OBJECT REPOSITORY?
can anyone help me in getting unix on manual testing i.e can u forward material & web sites to my mail id (suresh_57599@yahoo.com) to understand how the work flow working on manual testing on unix and the contents.plzzzzzzzz help me its urgent.
What do you think the role of test-group manager should be? Relative to senior management?
How can you do the scalability testing?
What and why is api testing?
What is a test severity and test priority? difference between them with suitable examples?
When first time we are testing the screen then we have to write that this screen should contains so & so columns [ suppose there r 10 columns on that screen]in the expected result
what is agile model and spiral maodel?pls explain with an example?
Changes and enhancements to system?
what r u r responsibilities in current project
What are the advantages of waterfall model?
How can I done a Web Testing? Which steps are include in it?
what is the difference between website and web based application ?
what is data guidelines
write test cases on wall