Aggregate Function shows Negative results although formula is correct

Questions & Answers
1

Hi Team,

I have created below is formula:

Aggregate({
[Issue Subtype].[S/4HANA Report],
[Issue Subtype].[EDW Report],
[Issue Subtype].[Regression]
})

Report shows negative values, but Individual Calculated members shows correct values

image
image975×191 40 KB

Thank you in advance for the help!!
Swapna

2

Hi @SWAPNARAMESH,

Subtraction of tuples within a calculated member is an efficient option for the exclusion of a member from a dimension. However, that has limited usability within further calculations.
It looks like the members that you aggregate are already calculated members. Therefore, the aggregation leads to negative figures.

Please export and share the report definition as described here - Export and import report definitions, or please share the definitions of the following calculated members:
[Issue Subtype].[S/4HANA Report],
[Issue Subtype].[EDW Report],
[Issue Subtype].[Regression]

Further details would allow seeing the actual reason and might allow suggesting a better solution.

Regards,
Oskars / support@eazyBI.com