Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expression in text box to calculate xirr value

Hi all

can anyone help - what would be the expression to write as an input in text box for calculating xirr value by taking variables as input.

The two variables are var (holds payment) and var1 (holds date).

Any help would be deeply appreciated.

thanks

4 Replies
adamdavi3s
Master
Master

Exclude my ignorance with the xirr formula as it's not something I have used before, but don't you need a range of data including income and payments to calculate it rather than one row?

Anil_Babu_Samineni

Can you share the variables please?

LET Var1 = Sum(Sales)

LET Var2 = Count(Sales)

If you want to calculate Average, Take Text object and use this

='The Average is' & ($(Var1) / $(Var2))

might be, We can help you if you really share those variables

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

we calculate xirr(amount,date)

where date is a filed name in script and amount is filed name in script

so how to find xirr when i have these two things in variables, what would be the expression?

Not applicable
Author

here i have attached the file

the variables are holding the amount and date, now i want to know the expression to find xirr using the values in variables.

Or is there any other way round, that wil also help.

thanks, any help would be appreciated