Calculate TWR
Dear Ninox experts
Can someone help me calculate the TWR? I have a table called "Asset_Manager" and a subtable called "Development." In "Development," there are various entries for each asset manager with a "period_return" (r). The formula for calculating TWR is TWR = ∏(1 + r) - 1.
I tried the following formula in the "Asset_Manager" table, but it results in infinity. What am I doing wrong? I want to calculate the TWR from all "period_return" (r) values for each asset manager in all the related entries of that asset manager in the "Development" table.
let twr := 1;
for r in Development do twr := twr * (1 + r.period_return) end;
twr - 1
Thank you very much for your help!
Pascal
2 replies
-
I don't know the TWR formula so I can't help you there, but I tested out your code with a number field with some data and the formula seems to work.
I have a parent record with a 5 child records. The five numbers are 1,3,4,6,9. I have the following formula in the parent record:
let twr := 1; for r in Table1a do twr := twr * (1 + r.Number) end; twr - 1and I get the result of:
2799
What kind of data is generated in period_return?
-
Thank you very much for your help and your confirmation. I checked everything again and found that I had mad a mistake in the parent table. Now everything works as planned. I am sorry for the unneccessary question. But your confirmation helped a lot.
Content aside
- Status Answered
- 2 wk agoLast active
- 2Replies
- 41Views
-
2
Following