Calculation on web template

[Former Member]

Hi.

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?

Cheers

Anand

I want to put two queries on a template

[Former Member]

You could do it my using the Table API. You can find each value in each query and then do the calculation in the class.

http://help.sap.com/saphelp_nw04/helpdata/en/b3/f4b1406fecef0fe10000000a1550b0/content.htm

Thanks,

Jeff

[dielom]

Hi Anand,

Option 1 is the correct one. Option 3 is not possible.

Regards,

Diego

[Former Member]

Is there any other way without using the multicube/workbook option?

Cheers

Anand