negative values to be excluded from a report

[Former Member]

Hi friends,

In a report i have a calculated key figure total quantity. user dont want these negative kg's appearing in the field. total quantity is a key figure

NODIM ( 'Qty- COPA Aquarius' + 'Qty- WBS' + 'Qty - COPA BA' + 'Qty - Old Billing type with BA type' - 'Qty - Use Risk Cancellation' - 'Qty - Usage Billed EPC' )*

user wants the kg's that are negative should not appear in copa.can any suggest what is the appropriate step to resolve this issue.

thanks,

ALI

[gunesbt · Accepted solution]

Hi,

I think you want to exclude the negative values from total, don't you?If you want to add only non-negative values to total then you must create a formula and write (Qty>0)Qty+NOT (Qtt>0)0 using Boolean operators.This formula means: if Qty>0 then Qty, else 0. However, you must do this for each Qty(e.g for COPA Aquarius,WBS,...) and then you can hide the real values of them if this is requiered, too.After that put the formulas you have created into the NODIM.

For more information about Boolean Operators:

http://help.sap.com/saphelp_nw2004s/helpdata/en/23/17f13a2f160f28e10000000a114084/frameset.htm

Regards,

Güneş

[Former Member · Accepted solution]

Hi,

Thanks for replying, I dont want to make the values in kgs as zero actually but whenver there is a value for TOTAL REVENUE there should be no value in TOTAL KG. this field should be blank and vice versa. Am getting these values for both the fields only for some particular orders. Remainining orders are fine.Where when one field is populating data the other field is blank. can you please give a solution for this.

Regards,

ali.

[ravikanth_indurthi · Accepted solution]

Hi,

You can create a new Condition:

Go to query designer->Condition->Create new->select New

Key figure -> Total Sales

Operator -> Greater Than

Value -> 0

Check this:

[Defining Settings for Condition|http://help.sap.com/saphelp_nw70/helpdata/en/54/a493f7256b43698191a2623e5a0532/frameset.htm]

Hope this helps....

Rgs,

Ravikanth.

[former_member182343]

Better to maintaing condition - less than 0.

[Former Member]

Hi friends,

I dont want zero in the place of negative values but i want a blank space. Is that possible in Bex or you think there is a problem in key figure.As for other values whenever there is a value for TOTAL REVENUE there is blank value in TOTAL QTYand vice versa. both are calculated key figures.could anyone give me a solution for this.

Thanks & Regards,

Ali.

[anshu_lilhori]

Hi,

i think if you go to query properties there is an option to display zero as space just check that out it may be helpful.

Regards,

AL

[ravikanth_indurthi]

Hi,

You can display the zeroes as Blank in query designer, as the above post has suggested.

Go to the Query Designer->Query Properties->Value Display->Display Zeroes as "Space".

You can use Zero as default text saying "No Value".

Hope this helps....

Rgs,

Ravikanth.

[Former Member]

Hi,

You can try using condition

Create a condition by giving total quantity > 0.

Thanks

Riyez