on 01-10-2017 1:34 PM - last edited on 02-03-2024 5:28 PM by postmig_api_4
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In Database we have 510. So unchecked the "retrieve duplicate rows" and got correct data as per DB. but when I tried to sum those data in a individual cell then again I am getting wrong total 13320. I need to get 510 even in individual cell. If you refer my attachment I have used same formula but the result is different.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.