Skip to Content
avatar image
Former Member

Display Amount In Reverse Sign Based On Property

Hi all,

There is requirement to input data in positive value and later to be displayed in report in negative value.

Is there any way to display amount in reverse sign value based on dimension property ?


This can be done by creating 2 records in database, one for input and one for report, but is there a way for 1 record from database only to be display reverse when user input ?

I tried EPM formatting sheet, but cannot find correct formula.

Thanks.

input.jpg (21.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 27, 2017 at 06:16 AM

    This is the usual behaviour in BPC system, Accounts of type INC or LEQ will have reversed sign in the reports. But I am not sure if you are referring to ACCOUNT dimension or not.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 27, 2017 at 07:15 AM

    In order to show value with diffenent sign on the report you have to create custom measure and use it on the report.

    Add comment
    10|10000 characters needed characters exceeded