Skip to Content
avatar image
Former Member

Sum function retrieving duplicate rows. How to remove?

capture1.pngcapture3.pngWhen I directly drag and drop the object I am getting less value but when I create new cell with sum function for the same object, then I am getting wrong result

capture1.png (11.0 kB)
capture3.png (10.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 10, 2017 at 01:39 PM

    This is happening because you have duplicate values.

    Right click on the table->Format table->checked the checkbox "Avoid duplicate row aggregation" and you will get the total sum 13320.

    to avoid this edit the webi query->Properties->uncheck the checkbox "retrieve duplicate rows" and see.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2017 at 11:58 AM

    Hi Nithya ,

    It appears your issue is because of calculation context .

    Go through https://michaelwelter.wordpress.com/2011/07/31/removing-the-confusion-from-calculation-contexts/

    Add required dimensions to the formula .

    Regards

    Sateesh

    Add comment
    10|10000 characters needed characters exceeded