Skip to Content

Display Amount In Reverse Sign Based On Property

Apr 27, 2017 at 02:39 AM


avatar image

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.


input.jpg (21.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

sakshi Jain 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.

10 |10000 characters needed characters left characters exceeded
Vadim Kalinin 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.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Vadim, thanks for the suggestion.

But when I create new custom measure (from UJA_MAINTAIN_MEASURE_FORMULA) and use it in the input form, input data & save, it is fail.

The message: "Measure formula (PERIODIC1) is different than the model storage type (PER)"

I just copy from PERIODIC formula name and nothing changed. Does it means cannot save data using custom measure ?


You can't save data with custom measure selected, it's obvious. You have to save data using standard measure but in report you show data with custom measure.