Skip to Content
author's profile photo Former Member
Former Member

BPS Layout : Total with + / - sign

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Dec 09, 2004 at 07:22 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.