BPS Layout : Total with + / - sign

[Former Member]

Dear all,

I have a layout like the following:

_____month 1_______month2

A 10 10

B 5 5

C 5 5

A row is a total = R(2)+R(3).

If I set B & C using Sign attribute (0SIGN_REV) function.

The result become :

_____month 1_______month2

A 10 10

B -5 -5

C -5 -5

The total A didn't change to -10.

I run UPP_SET_CALC_FE_ON to run the result locally in excel.

In layout edit data mode, I got A = -10.

But, in layout display data mode , A become 10 again.

Is there anyway to set A = -10 any both edit and display mode? And, the UPP_SET_CALC_FE_ON only work for excel interface. How do you handle this kind of issue in web?

Best Regards,

Jeff

Message was edited by: Jeff Huang

[former_member93896 · Accepted solution]

Hello Jeff,

the system should work consistently across all user interfaces i.e. a total row must always show the sum of all values. Please open an OSS message to get a correction.

Regards,

Marc

SAP NetWeaver RIG, US BI

[Former Member · Accepted solution]

Hi Marc,

Thanks for the reply. I will open a oss for this issue.

Best Regards,

Jeff