on 09-27-2018 3:11 PM
Experts,
Platform : SAP BusinessObjects BI Platform 4.2 Support Pack 5 Version: 14.2.5.2618
In a SAP Webi Document, there is a cross tab.
In the footer part, there is aggregation happening for all the columns but the values which it is bringing is in-correct.
Now a part of functionality that is being shown in the document. Report does not show (<6 values) any where in the cross tab due to some regulation.
Options tried : I used RunningSum of the measure used in the document. But was getting #UNAVAILABLE error.
Measure in Universe has below formula ::
CASE WHEN sum(<<Schema>>."QUANTITY")>5 THEN sum(<<Schema>>."QUANTITY") END
I would like to know where did i go wrong or to which place I need to modify.
Attaching the screenshot where in
1 line is reporting footer which is wrong
Below line has the correct values.
Need your help.827.jpg
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.