Hi All,
I have the below raw data and need to calculate XIRR
![Shamshad_0-1637643642488.png Shamshad_0-1637643642488.png](https://community.qlik.com/t5/image/serverpage/image-id/67222i627CA62EB9645521/image-dimensions/573x310?v=v2)
Requirement - Calculate XIRR of the script based on the date selection.
Challenges - Bringing Opening and Closing values to the table based on the date selection.
Validations
1. Do not consider opening value, if opening value is Zero or less than zero.
2. Opening value should be considered as a cash outflow on that date (Reverse the sign of the stock value)
3. Closing value should be considered as a cash inflow on that date.
We need below table in qliksense & added XIRR Scenario too.
![Shamshad_1-1637644048245.png Shamshad_1-1637644048245.png](https://community.qlik.com/t5/image/serverpage/image-id/67224i91EA275D50B87F21/image-dimensions/726x271?v=v2)
Please find XIRR file in the attachmnet.
Could anyone please help me to achieve above requirements.
Thanks