Error in calculating irr in asp.net and vb.net

Originally Posted by asmasm1

thanks shweta123

I think there is type mismatch in parameter types while calling the following function :

ir = Math.Round(Microsoft.VisualBasic.Financial.IRR(pay (TextBox2.Text + 1), 0.1), 2).

as i am passing arraylist (pay(15) as ist parameter and guess (0.1) as 2nd
parameter the variable ir is taken as double
as irr function will only return the value of irr which would be double

Originally Posted by shweta123

Hi,

Following is the method for solving the error you are getting :

1> Please see the function definition and check the parameters your function is accepting.
2> Call the function with same types of parameters.
3> If you are sending different types of parameters to the function then
you can call the function by doing typecasting method.

Originally Posted by asmasm1

thanx dirtbag

I am developing application for loan purposes and i have to calculate irr
textbox2.text specify the no installments
those no equal installments are added to arraylist
<code>
//For i = 0 To TextBox2.Text??
// Add elements of array list
//for(int 0;i<Convert.ToInt32(TextBox.Text);i++)//

ir = //YOURFUNCTION(pay[index],0.1,2);
//(pay (TextBox2.Text + 1), 0.1), 2)
// what exactly are you passing in the function?
</code>

passing arraylist (pay(x) as ist parameter and guess (0.1)
as i have also mentioned whole problem in my posts
thanks again for response

Originally Posted by asmasm1

hi dirtbag
'code Starts
Dim i As Int16
Dim pay As New ArrayList()
For i = 0 To TextBox2.Text
pay.Add(TextBox5.Text)
Next
pay.Add(-TextBox1.Text)
Dim ir As Double
ir = Math.Round(Microsoft.VisualBasic.Financial.IRR(pay (TextBox2.Text + 1), 0.1), 2)
TextBox7.Text = ir
'code Ends

GETTTING THIS ERROR MESSAGE
Unable to cast object of type 'System.Double' to type 'System.Double[]'.