Skip to Content
author's profile photo
Former Member

BEx Report - % to SALES

Dear All,

I am working on Report for P&L account.

The Columns of the Reports is as follows:

GL Account Plan Actual Variance <b>% to Sales</b>

Sales 100 120 20 100

Material 30 35 5 29

D.Labour 10 10 0 8

Total Variable Cost 40 45 5 38

Accounts are grouped as Structures (Grouping of Account Codes)

Pls guide me how to generate the Last Column in the report - % of Sales for all other GL Accounts.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Aug 09, 2007 at 06:53 AM

    Hi Satish,

    Try to use the Percentage Share option i.e %A(Sales)

    Kindly confirm if it works

    Thanks

    Vikram

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      In your query designer there is a Define Cells icon on the toolbar, select this. (Note that unless you have two structures in your query this option is not enabled)

      You are brought into a new dialogue box where you will see the elements of the structures in the rows and columns.

      There are two things you will do here, the first is to 'Mark' a cell that will be used in your formula, the second is to create the formula. Look at where the cell intersections are for the Total Sales figure, right mouse click it and select New Cell Reference. I think you will Cell Reference each of your rows so that you can get a % of this figure versus your total sales figure. Also Cell Reference the Total Sales Figure.

      Now that you have Cell References the rows, when you go to create a formula these cell references are available in the bottom left hand panel for selection. Create you formula for each of your rows where you will use the Cell Reference as a % of Total Sales.

      Hope this may help,

      Regards

      Gill

  • author's profile photo
    Former Member
    Posted on Aug 09, 2007 at 03:16 PM

    Hi there,

    If you use the Define Cells option, you can calculate any figure as a % variance on Sales this way.

    You can use Define Cells if you have two structures in your report. When you select the icon in the Query Designer, you will see the cells of your report. All you will have to do is to Name your Sales Actual cell (right click it) and then this cell becomes available as a key figures within the Define Cells structure to calculate the other GL Account elements. You will have to put a formula in for each GL Account.

    Regards

    Gill

    Add comment
    10|10000 characters needed characters exceeded