Skip to Content

Bex Query Designer, condition values detailed different to summation

Hello experts

I can collaborate with the following incident

as do to reconcile detailed with each group total and grand total values. SAP Bex Query Designer

I have a condition, to get greater values 0

detailed values do not match the values summation

sending images of the process.

Thank you

yimi castro

3 Captura .png (108.5 kB)
4 Captura .png (144.0 kB)
5 Captura .png (64.8 kB)
6 Captura .png (174.2 kB)
7 Captura .png (63.9 kB)
8 Captura .png (54.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 05, 2016 at 02:28 AM

    Hi,

    did you apply condition on individual characteristics by choosing "comuna" and "referencia" ?

    if you choose only one row in condition definition, then you tried to add another rows in the drill down at query analyzer level, you wont get correct results.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Yimi Castro

      Hi Yimi,

      if you want to see both summary or details value greater than 0 in same report on the fly, then you create two new conditions, and try below and see.

      1) for detail, (only prodcut in rows)

      value >0 apply condition on individula char : prodcut, brand

      2) for summary, (when you remove product from rows )

      value >0 apply condition on individula char : brand

  • Apr 05, 2016 at 10:23 AM

    Hi Yimi,

    if you use conditions and don´t tell the sysem any different, it´s doing the total always without considering the condition.

    If you want to have something different, go to the properties of your key figure in query designer,

    got to calculations

    choose the totals calculation method that you want to use

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Yimi,

      check the settings for the key figure - maybe there is something wrong for the sigle values.

      Or there is an exception aggergation set for the more detailed char that you are aggregating into the commune - sorry, but the screenies are so small, I can not really see what it is.

      regards

      Cornelia

  • Apr 12, 2016 at 11:37 AM

    check settings for calculate result as for the keyfigure in Bex query definition.

    Hope this helps.

    -Swati.

    Add comment
    10|10000 characters needed characters exceeded