How to create a "Per Member Per Year" calculated measure?
Posted on January 27, 2017 at 2:20pm
Trying to create the following Excel formula in JasperSoft: Ad Hoc Views.
=Total Gross Cost/Total Members/Months*12
Any ideas?
Thanks!
Joined: Jan 19 2017 - 1:32pm
Last seen: 6 years 7 months ago
Posted on January 28, 2017 at 7:51am
Do you mean Total Gross Cost/(Total Members*Number of Months*12)?
To find Number of Months, I would try something like Year(Max(Date))*12+Month(Max(Date)-Year(Min(Date))*12-Month(Min(Date)). You might have to cast the Year and Month as integers
Joined: Mar 5 2012 - 9:19am
Last seen: 3 years 1 month ago
