Skip to Content
avatar image
Former Member

How to to remove sum of repeating value for Key figure

Hi ,

I am getting below scenario in report :

For current MR Reading column in DSO( first record in screenshot ) , there are two records which are aggregated at query level. each record has value 300 and 300.

In final layout , I dont need to aggregate this Key figure. But I want to display only 300 , for final record. ( first record )

Is there a way to acheive this?

Please suggest.

Thanks!

Data.PNG (6.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Oct 30, 2015 at 01:44 PM

    Hi Raju

    Please give some background for the issue. This should be better handled in DSO level and not in query level. Whatever it is in DSO, it shows in the query.

    First check why do you have two values in DSO. Is it because of some characteristics being different for the two records or any other specific reason?

    You could simply divide the keyfigure by 2 but that will not be the correct solution. Please check the points and give us more details with screenshots if possible

    Regards

    Karthik

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Raju

      Then you should think of enhancing the infoprovider level information. What are you doing exactly to get double values. Do you have any routines or something to write the record two times? or do you use self transformation?

      Please provide the details of the data flow. we will check and fine tune it for your requirement.

      Regards

      Karthik

  • Oct 30, 2015 at 03:45 PM

    Hi Raju,

    Did you try below setting.

    Key figure-->properties-->Calculations-->Calculate Result as "First value".

    Thank you,

    Nanda

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 30, 2015 at 07:41 PM

    Hi Raju,

    You can handle this type of repeated value getting in report by using exception agregation property setting in Bex report.Before set expection agregation in the report,you need to check the data set base on which characteristics, value is repeating.So that you can set exception agregation base on that characteristics and calucaltion Results as First Value.

    Regards,

    Rajesh


    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2015 at 10:57 AM

    Hi Raju,

    check in dso, what is key, and is there field values difference between them 300 values records.

    change 'MR current reading' KF aggreation property.

    pls share screen shot for above scenario from DSO ?

    Regards,

    Hitesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 11, 2016 at 09:25 AM

    Hello,


    I am having the same issue on ByD

    Indeed I would like the following report :

    I would like the calculated key figure to make an agregation of the total of the amounts of the bills,(for every unique bill? When the bill is not repeating? etc???,). My goal in the following simplified example would be to have 890 (that the indicator do not count the amount when the bill is the same). this way, it would allow a simple comparaison between what's collected & what's the factured amount.

    Is there any way to do it? Is it necessary to re-edit the joined date sources in order to make a key anywhere? There are also multiple characteristics concerning every collected amount, like the date, etc...

    I hope it can relance the subject & help Raju by the way, i have been looking for a few time already, any help is welcome.



    here is a link to the ByD Thread :

    Regards


    Victor


    tabtest.png (6.3 kB)
    Add comment
    10|10000 characters needed characters exceeded