Skip to Content
avatar image
Former Member

Problem with porcentual function in hierarchy

Hi friends;

I have a issue in bex query designer with a porcentual function. I attached an example of what I need, what I need is a percentage based on the total of each group of the hierarchy (0MATERIAL) and not on the overall total:

I test with %CT and %GT functions, but booth works with the total general, and not with total group...

Y need the values of the column "MIX (value OK group material" and not the values of the column "MIX (error)".

Hierarchy

Quantity

MIX (error)

MIX (value OK, group material)

Materials (general)

45

100

100

Group Materials "X"

30

66,67

100

Material X1

20

44,44

66,67

Material X2

10

22,22

33,33

Group Materials "Y"

15

33,33

100

Material Y1

5

11,11

33,33

Material Y2

10

22,22

66,67

Any idea to solve this?

Best regards!

César.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 03, 2015 at 08:07 PM

    Your thread is under incorrect forum.

    Create a new one here:

    SAP Business Explorer (SAP BEx)

    We are query experts over there 😉


    Best regards,

    Edward John

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2015 at 06:55 AM

    Hi César Garrido,

    Please check below thread it may help you.

    How to use Percentage Functions in Bex Query Designer

    BR,

    Praksah K

    Add comment
    10|10000 characters needed characters exceeded