Substraction of two key figures normalized to results not working as expect

[Former Member]

Hi All,

I am having problems with getting the right result from a subtraction of two KFs which are "normalized to results" which means the KFs really have values expressed as percentages. The substraction that should be performed is of two percentages (e.g.: 87.298% - 85.527% = 1.77%) but my report prints out the result as "number of units" instead (e.g.: 87.298% - 85.527% = 71,514.00 EA). The two normalized KFs actually "point" to two stock KFs, hence the "number of units".

Thanks & Regards,

Venkat Vanarasi.

[Former Member · Accepted solution]

Hi,

The subraction will be carried out before doing the normalization of your KF's. So, it is displaying "number of units". Create a calculated keyfigure and subtract the KF's and in the properties of this calculated keyfigure, change the enhancement as "After Aggregation".

I hope this will solve your issue.

Regards,

S P.

[Former Member · Accepted solution]

Hi SP,

Thanks a lot, Now i am going to aplly the same. Let me seet the results okie... Will catch u soon

Thanks & regards,

Venkat Vanarasi.

[Former Member · Accepted solution]

Hi SP

where is the option "After Aggregation" in query.

and will it give value in %.

Regards

SSMS

[Former Member · Accepted solution]

Closed