pathfinder2104.work Posted March 14, 2014 Share Posted March 14, 2014 Hi all,Thank you all for responses to my question and for reading them,I post a question about creating a third column which is derived from the two values in same row. Now the question is to calculate the average of this column. How can I calculate the average? Thank you. Link to comment Share on other sites More sharing options...
pathfinder2104.work Posted March 14, 2014 Author Share Posted March 14, 2014 I am able to display the total. Link to comment Share on other sites More sharing options...
pathfinder2104.work Posted March 14, 2014 Author Share Posted March 14, 2014 I am using a list to display this data and I want to display the average out side the list. (Just below the list). I am calculating the third column using the "total sold" and "total in stock" columns Link to comment Share on other sites More sharing options...
Solution hozawa Posted March 15, 2014 Solution Share Posted March 15, 2014 If you have the total, just use the .divide() to find the average. Link to comment Share on other sites More sharing options...
pathfinder2104.work Posted March 15, 2014 Author Share Posted March 15, 2014 One question is I can create total just by drag and drop that % field in my report but can I store it in any variable just like I do in programming language ?? Further I want to use this stored variable value in my calculation can I do this ?? If I can How ??? Some pointers or some examples needed if you can provide any that would be great help. Link to comment Share on other sites More sharing options...
hozawa Posted March 16, 2014 Share Posted March 16, 2014 When you drag and drop and create SUM, Jaspersoft Studio will create a variable (ie. $V{}. Read up on using Variables in Jaspersoft Studio in "Jaspersoft Studio user Guide" Chapter 9: Variables Link to comment Share on other sites More sharing options...
pathfinder2104.work Posted March 18, 2014 Author Share Posted March 18, 2014 The trouble is that sum variable is inside a list and the total part that I am showing is outside the list, Now I created a third column dynamically and I want to calculate the average of this third column outside the list. is it possible? 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