How to create a "Per Member Per Year" calculated measure?

Trying to create the following Excel formula in JasperSoft: Ad Hoc Views.

=Total Gross Cost/Total Members/Months*12

Any ideas?


alackey's picture
Joined: Jan 19 2017 - 1:32pm
Last seen: 6 years 7 months ago

1 Answer:

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

elizam's picture
Joined: Mar 5 2012 - 9:19am
Last seen: 3 years 1 month ago