how can i achieved this kind of report in LN...

im really new at this system, i still don't know the work around
how can i add fields that compute in report?


this must be the output
Code |Description |Series | Ave Usage(2015) |Months(REMAINING)
MLC1 |TD paris SO |1234 | 40,000 |9876.5


Thnx in advance!

Hi,

If you are new to LN programming I will suggest you to study basic select queries first. Then go for table joins and nested select queries.

You need to get in touch with the users to check what is their requirement, from which session/table do they want the values and like wise you can build your own report.

The columns mentioned i.e. Series, Ave Usage(2015), Months(Remaining) does not provide enough details to suggest a solution. It will be better if you study the data first and post your questions.