How can I create complex variables?

[oliverk_1]

Hello Jaspersoft Community,

I am a new user of Jaspersoft and I am trying to create variables that can help me analyze financial data. For example, how can I go about recreating the Sharpe ratio calculation given a set of historical data and a daily PL (or cumulative) of a set of trades? (ROR_Portfolio - ROR_{Risk Free}) / STD_Portfolio. If I am unable to do this, I can imagine a function doing this separately and passing it in, but how/where would I enact this function?

I am trying to find detailed documentation for how to use Jaspersoft but I have been unable to find what I am looking for.

Help would be greatly appreciated. Thank you in advance!

[marianol]

Your best best for complex calculations is to use report Scriptlets and helper functions. Here you have a nice tutorial http://www.tutorialspoint.com/jasper_reports/jasper_report_scriptlets.htm and you also have the samples in JR  http://jasperreports.sourceforge.net/sample.reference/scriptlet/ 

Some other sources:
- http://community.jaspersoft.com/blog/all-you-want-know-about-scriptlets
- 

- and as always Google is your friend try "jasperreports scriptlet" or "jasperreports scriptlet tutorial"