Skip to Content
avatar image
Former Member

BEx Query Percentage at Overall Result

Hi everybody,

I have an issue that I can't solve with a percentage calculation in a query at overall results.

Here my actual result:

As you can see at Overall Result I'm getting an X when I have to get a 0,24%.

The formula that calculates the last column is NODIM ( TOTAL HOURS)%_ANODIM ( PARCIAL HOURS), with no Aggregations and no Calculations options.

TOTAL HOURS and PARCIAL HOURS are query formulas too.

Can you help on how to obtain Overall Result Percentage value?

Thanks in advance and best regards.

a.jpg (45.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Aug 30, 2017 at 04:41 AM

    Hi Marce,

    Can you please try Calculate Result as Summation of all single Values on that formula

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 05, 2017 at 11:40 AM

    Hi Marce,

    in your screenshot we can not see the values for TOTAL HOURS and PARCIAL HOURS

    what are those values in the result line?

    When you get the X it seems to me, that one value is probably 0

    So either you correct those values, or do what Ashu recommends change the setting for the reult in your "Break in Work%" Key figure.


    regards

    Cornelia


    Add comment
    10|10000 characters needed characters exceeded

  • Sep 11, 2017 at 06:53 AM
    -1

    Hi,

    Please show also the values and formulas for total hours and parcial hours as these will help us understand why you get the value of "X".

    Anyway, I think the solution is you apply exception aggregation to your BREAK-IN WORK with SUMMATION.

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      The solution I have suggested works only in the TOTAL RESULT side and not the summation of the result of the formula.

      So for this formula,

      FORMULA = NODIM ( TOTAL HOURS)%_ANODIM ( PARCIAL HOURS)

      It will only compute based on the FINAL SUM RESULT of all line items. It will not add 0.24 + 0 as what you are saying.

      Let's say I have this sample data based on the result above:

      TOTAL_HOURS --- PARCIAL_HOURS --- FORMULA

      0 --- 0 --- 0

      24 --- 100 --- 0.24

      OVERALL_RESULT --- 24 --- 100 --- 0.24

      Assuming that 1st row has value like below, using EXCEPTION AGGREGATION with SUMMATION will give us this:

      TOTAL_HOURS --- PARCIAL_HOURS --- FORMULA

      60 --- 120 --- 0.5

      24 --- 100 --- 0.24

      OVERALL_RESULT --- 84 --- 220 --- 0.3818

      Exception aggregation result will be 0.3818 and not 0.74 (0.5 + 0.24) as what you are saying should be the result.

      ...

      Anyway, if ever my answer is incorrect what should be the solution? So we will know how to solve this kind of problem.

      Regards,

      Loed