Display Amount In Reverse Sign Based On Property

[cosmas_phepar]

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.

[former_member186338]

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

[cosmas_phepar]

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 ?

[former_member186338]

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.

[Former Member]

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.