Calling Financial Functions

[milindsd]

Hi,
You can use Excel formulas, in the QTP Data Table.

Bellow is the example:
'''-------------------------------------------------------------

Code:

DataTable("Formula", dtLocalSheet) = "=PV(10, 48, 200000)"
valPV = DataTable("Formula", dtLocalSheet)

DataTable("Formula", dtLocalSheet) = "=PMT(10, 48," & valPV &")"
valPMT = DataTable("Formula", dtLocalSheet)
Print "PV: " & valPV
Print "PMT: " & valPMT

'''-------------------------------------------------------------
Hope, this would help you!

Thanks,