Skip to Content
author's profile photo Former Member
Former Member

Repetitive values

Hi,

Client requirement for the report, this is how the report is displaying right now

Sales Document Material Number of Sales Document

61000276 903215 1

61000279 903251 1

61000280 904512 1

907653 1

908765 1

_______________________________________________

Result 3

Count is working fine but the value 1 is repetitive, for the sales document 61000280 the value should show as 1 and for the rest of the two it should show blank.

the report should display like this

Sales Document Material Number of Sales Document

61000276 903215 1

61000279 903251 1

61000280 904512 1

907653

908765

_______________________________________________

Result 3

any help would be appreciated, as its very urgent.

Thanks

BR

venkat

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Dec 14, 2011 at 02:49 AM

    Hi,

    This count is coming based on unique value of material rather than on sales document.

    Try to put exception aggregation on your count...Reference characterstic as sales document.

    Please check out the below thread as well.

    Hope it helps.

    Regards,

    AL

    Edited by: AL1112 on Dec 14, 2011 4:07 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 14, 2011 at 04:10 AM

    HI,

    Create Calculated KF at Bex level (Count) and keep Exception aggregation as sum - Tke reference as Sales Document number.

    Kindly ask if you have any queries.

    Regards,

    rvc

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 10:08 AM

    Hi,

    Thanks for the replies,

    probably I am not clear in my last message,just to make it clear

    Actually I am using the count on Sales document number and also Sales doc Items and we need to display both the values for example

    1 Sales document could have 3 Sales Doc Items so it should display for

    Number of Sales Document as 1 and for Number of Sales Doc Item as 3 and

    accordingly I did the count and aggregation with Counter for all detail values for

    Sales document Number and Sales document Item, the count is working fine....its showing 1 and 3

    But my problem when its displaying in the report Irrespective of showing only 1 value in Number of Sales document its showing

    1

    1

    1

    Count = 1 ( Display value should be only 1 not three 1 the rest of the two should be blank or 0 )

    and for Document Item

    1

    1

    1

    Count = 3

    so for Sales Document Number it should show the value as 1 and the rest of the fields as Blank as its only 1 sales document .

    Hope I am clear with my problem, please do let me know if you need more details

    Appreciate your help guys.

    Thanks in advance.

    BR

    Venkat

    Edited by: Venkat on Dec 14, 2011 11:11 AM

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      I am little confused with your requirement now.You have two different fields which shows count or only one field.

      Please be precise and paste the output in better format once again for refernce.I will try the same on my system and will check how it behaves.

      Regards,

      AL

      Edited by: AL1112 on Dec 15, 2011 5:56 AM

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.