Skip to Content
author's profile photo
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on Jun 30, 2008 at 08:31 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded