Skip to Content
author's profile photo Former Member
0
Former Member

BEx display in sigle line

Posted on Oct 10, 2010 at 09:32 AM 12 Views

Hi All,

I would like to display below scenarion in single line.

I have data in query like below.

Zone Job Completion time (deriving with formula in BEx)

Z1 J1 20

Z1 J2 16

Z1 J3 11

Number fo Jobs with respect to Completion time is greater than 15 should display on Zone wise like below

Zone (Greate than 15 Jobs) Total job (percentage of jobs greater than 15)

Z1 2 3 66.6 per (i.e 2/3)

I have written a formula on Completion time wih 0 and 1 (if greater than 15, result 1 one else 0)...

But my output is coming like below.

Zone (Greate than 15 Jobs) Total job (percentage of jobs greater than 15)

Z1 1 1 100

Z1 1 1 100

Z1 0 1 0

................................................................................................................

But i need like below in single line. how to achive the same in the report.

Zone (Greate than 15 Jobs) Total job (percentage of jobs greater than 15)

Z1 2 3 66.6 per (i.e 2/3)

Thanks in advance

Regards,

Raj

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Priya Jacob
    Priya Jacob
    Posted on Oct 11, 2010 at 06:55 AM
    2

    Hi Raj,

    1) Drag 'Zone' in your Rows

    2) Under Columns, create CKF1. Include formula as (Completion Time > 15) * 1. Under Aggregation tab, select Exception Aggregation as 'Total'. Select 'Job' as your Ref. Characteristic.

    3) Under Columns, create CKF2. Include formula as (Completion Time < = 15) * 1. Under Aggregation tab, select Exception Aggregation as 'Total'. Select 'Job' as your Ref. Characteristic. Keep the Display as 'Always Hide'.

    4) Under Columns, create CKF3. Include formula as CKF1 + CKF2

    5) Under Columns, create CKF4. Include formula as CKF1 / CKF3 * 100

    Plz. validate if your O/P is in the form

    Z1 2 3 66.6

    --Priya

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.