cancel
Showing results for 
Search instead for 
Did you mean: 

Bex Query Designer, condition values detailed different to summation

s0009656058
Explorer
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

s0009656058
Explorer
0 Kudos

hola jyothi

Question

1. as I can make a detailed report take the condition values greater than zero?

2. the current condition, does not take values greater than zero, but added to the total.

how to make records excluded not add to the total?

thank


Yimi Castro

Former Member
0 Kudos

Hi Yimi,

you can apply condition(key figure) greater than zero to a specific row  .

ex : if you want to see product which is greater than zero, then you apply condition on value >0 and apply condition on individual char : product.

s0009656058
Explorer
0 Kudos

Hi Jyothi

I have a question, can you help me?

What I can do?

most condition 0, is working well for me.

summary for a filter is not working, as I can do?

that option active.

actualmete I have the condition value> 0

in the load / tab I calculated result as: totalization

what else would I can do?

example

summary

brand value1

01      140

Note: In group does not take the condition> 0, must give 135.

how to make

Detailed

Brand  Product  value1

01         Prod1      -5

01         Prod2     140

--------------------------------

Total .................. 135

Nota: in detail if it meets the condition value> 0

thanks for your help

Former Member
0 Kudos

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

Answers (2)

Answers (2)

swati_gawade
Contributor
0 Kudos

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

Hope this helps.

-Swati.

s0009656058
Explorer
0 Kudos

hi  swati

the calculation result as works for detailed report.

but does not work when I take the report grouped, summarized, does the condition Brand> 0.

Question:

I activate that parameter to mark the work condition> 0,, in summary report?

Thank you

cornelia_lezoch
Active Contributor
0 Kudos

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

s0009656058
Explorer
0 Kudos

hi cornelia

thank`s for your information

I am placing calculation summation, but the second line does not give the actual value.

you can tell me more I can change, so that the calculations match.




thank for collaboration

yimi castro

cornelia_lezoch
Active Contributor
0 Kudos

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