Average data Row for a layout in BPS

[Former Member]

Hi,

I have a Row with 2007 Data In My BPS layout and i want the another row showing average per month of 2007 data (ie) 2007/12.

I think this can be achieved by FOX. But i am not sure where i get this Formula function option.

Can any one please help me out how to achive this.

Thanks for the help

With Regards

Neetu

Edited by: Nithya Reddy on Jul 30, 2008 8:20 PM

[Former Member]

Hi,

Create a dummy row in the data column which doesnt retrieve anything and make it comparision column.. then write a simple macro and populate the cells of that column. This method is useful if you dont want to store the average in the cube and needed just for display. Hope you are using BPS.

Bindu

[Former Member]

Hi

I need your help.

I just need to add a simple TOTAL ROW for my BPS LAYOUT.

I only have the allowance to define column total checking the total check box in the data columns and then defining the C(1):C(7) in the total field.

But when trying to define a total for rows i also select the checkbox of total in the data column section and write the R(1):R(10) in the TOTAL field, but i get a sintax error.

Please help me, i just need to have a row for totals in my layout. Thanks in advance for your valuable help.

Regards

Carlos España.

[Former Member]

If you want the total for rows, you have to check one option in the last screen of the layout builder. There is one button called 'lead column settings', in that tick 'total' and 'show total'.

[Former Member]

Excellent!!

Thank you very much Bindu.

Your answer help me to have a Total.

Thanks a lot. Your answer was very helpful for me.

Is it possible to customize that total row, in order to define just what rows to make the sum. For example R(1):R(3).

Thanks again!!

Have a nice day.

Carlos España.

[Former Member]

We can't customize this, it always gives the sum of all the rows.

[Former Member]

Hi

Just check U can cretae a new item in u r layout and select the formula option and their u define the formula (Like: (R1) / 12 ) for that item and it will automatically take care that.

Thanks

Debasish