New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Beginners v
Question how to calculate formula in the data sheet

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Question how to calculate formula in the data sheet
cdesserich Offline
Member
***
Posts: 57
Threads: 0
Joined: Jan 2010
Reputation: 0
#2
Solved: 11 Years, 6 Months, 3 Weeks ago 10-01-2010, 11:22 PM
You have to put "=9+3" in the table cell just like Excel. The cell will display "12" unless the cell is being edited, in which case you will see the formula "=9+3". Summing values of other cells in the data table works the same way using Excel formulas. "=SUM(B1:B3)" will give you the sum of those three cells (B1, B2, and B3). Hope this helps.
Find
Reply


Messages In This Thread
RE: Question how to calculate formula in the data sheet - by cdesserich - 10-01-2010, 11:22 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Reading data from excel sheet serenediva 1 9,835 03-03-2017, 10:07 AM
Last Post: vinod123
  How import final calculated values by cell formula from Excel not the formula itself. qtped 1 4,980 01-17-2017, 04:05 PM
Last Post: sagar.raythatha
Question QTP not performing iterations based on local data sheet Breaker 18 57,457 01-25-2016, 04:32 PM
Last Post: arunshuklainbox
  Importing data sheet Santu 2 3,497 08-20-2015, 11:37 PM
Last Post: ADITI1992
  On Saving Script in QTP 11 my Global Data Sheet data is removed M Adnan Iftikhar 0 2,250 06-02-2015, 09:19 PM
Last Post: M Adnan Iftikhar

Forum Jump:


Users browsing this thread: 1 Guest(s)