alackey Posted January 27, 2017 Share Posted January 27, 2017 Trying to create the following Excel formula in JasperSoft: Ad Hoc Views.=Total Gross Cost/Total Members/Months*12Any ideas?Thanks! Link to comment Share on other sites More sharing options...
elizam Posted January 28, 2017 Share Posted January 28, 2017 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now