Forum Discussion
PRODUCTX calculation on total level
Hi all, I am dealing with the following issue: My table consists of investmentID's and for every investment I calculated the returns (Dietz method). In order to link the returns per period to...
Thank you for your response!
Returns is indeed a measure. I have tried your method but it does not work unfortunately.
It has become a complex structure with a return calculation based on two tables: one table with start and end value per period and one table with transactions during the period. Those two tables are linked and the formula to measure return works fine.
The problem is that it keeps calculating the product per investment return in stead of the product of the return of multiple investment within a period.
- stevedep
Memorable Member
For readability, I would suggest to simply use SUMX(Values..
