Bex query question:How to get total value ?

[Former Member]

For material level we can get value(quantityamount), but for the result is total quantitytotal amount, the result is wrong. How to get the total value correctly?

I checked some material.which need coding. but I want to know if I can get easier way for that.

Thanks.

[Former Member]

I will use cell editor for that,also we can check

http://help.sap.com/saphelp_sm40/helpdata/en/d2/02223c5f00612be10000000a11402f/frameset.htm

[Former Member]

http://help.sap.com/saphelp_sm40/helpdata/en/d2/02223c5f00612be10000000a11402f/frameset.htm

[former_member970842]

Hi,

U can create one more variable(Formula), called revenue= sales qty* price..hope it will solve...

[Former Member]

Yes, I created CKF=quantityamount, for material level the result is ok, but for the total level the result is not right(total quantitytotal amount), that is why I asked the question.

Thanks for your help!

[Former Member]

hi

Use Formula collision

calculate result as nothing defined

[Former Member]

I tried this way, it did not work.

Thanks.

[Former Member]

try other options in formula collision... result from competing formula...

reg,

Pradhiba

[Former Member]

Thanks, actually I tried the setting parameter all the afternoon, but nothing can help me. If you have good idea,Pls let me know.

[Former Member]

hi, i jus tried. .this works for me..

set calculate result as summation and formula collision nothing defined...

*reward if helpful*

[former_member183777]

In the Key Figure Property, set the calculate Results as to Summation.

[Former Member]

I tried already, It does not work!

Thank you for your help!