Jump to content

Can I use two values in same row to create a new value and display it as a third column?


pathfinder2104.work
Go to solution Solved by elizam,

Recommended Posts

Hello all,

I am supposed to create a report of a store where I need to calculate which items are sold more based on the total stock of items and total sold items and create a third column in report in percentage.
Is it possible to achieve this in Jasper report or I need to do something else ?

The report will look like as follow: I am able to fetch the item no, total in stock and total sold and I need to calculate the sold % based on total in stock and total sold.

converted-file.png.59cfa29a4af677b16fa165967bf1ad1b.png

Link to comment
Share on other sites

  • Replies 7
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

Need to carry out the calculation using the two fields of total in stock and total sold. (total in stock means when the shop opens at that time what ever was the stock) and this report is to be generated at the end of the day.) calculation would be 100*total_sold/total_in_stock using this calculation I want to display the precentage.
Link to comment
Share on other sites

  • Solution

For Jaspersoft Studio, I recommend looking at chapter 9, Variables, of the JSS User Guide.

http://community-static.jaspersoft.com/sites/default/files/docs/jaspersoft-studio-user-guide.pdf

You can create a variable and define an expression, which would be the calculation you want. Another possible calculation for the percent sold would be 100*total_sold/(total_in_stock + total_sold). There are problems with the calc suggested in previous answer, for example, if you sold everything, so total_in_stock = 0, you would get infinity for the percent sold, instead of 100%.

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...