Calculation on web template
I have the foll scenario:
I need to take the total sales value from a GL query, take the total sales in pounds from a sales query, calculate the revnue per pound and display all the above. I have the foll options:
1. Build a muticube with GL and Sales data and calculate. This would require me rewriting a few queries as the system is already live with GL.
2. I could the same easily through a workbook. But we want to avoid XL frontend
3.Now if I bring the GL query and the Sales query on a web template, is there anyway by which i can calculate and display those results in the same template at run time?
I want to put two queries on a template