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

NoFilter()-Sum() Not Working for a percent calculation?

I created a Top 10 Customer report and within this report I needed to list the total of all other customers.

When I went to input the % calculation of all others the NoFilter()-Sum() calculation does not calculate properly.

I thought it would correct itself it I enter NoFilter()-RunningSum(), this does bring the % to a better % but not to the correct answer.

I tried searching on line but cannot figure it out.

Below is the formula I am using:

=NoFilter([PY Actual Revenue %])-Sum([PY Actual Revenue %])

The formula to [PY Actual Revenue] is below.

=If IsNull(([YTD Data].[Revenue Actual])Where([YTDData].[Calendar Year]=Year(CurrentDate())-1)) Then 0 Else((([YTD Data].[Revenue
Actual]+0)Where([YTD Data].[Calendar Year]=Year(CurrentDate())))-(([YTDData].[Revenue Actual]+0)Where([YTD Data].[Calendar
Year]=Year(CurrentDate())-1)))/(([YTD Data].[Revenue Actual]+0)Where([YTDData].[Calendar Year]=Year(CurrentDate())-1))

How do I correct this formula so my spreadsheet when opened is updated accordingly weather the NoFilter total is a negative or a positive?

Thank you for your help!

(Scroll down to see example, you will see percent for Top 10 and Total is correct, but Other is not.)


















Top 10 2,422,725 2,017,837 20.07% Other 1,644,319 3,201,303 -248.41% Total 4,067,044 5,219,141 -22.07%
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Sep 02, 2013 at 02:04 PM

    Hi Elisete,

    You should actually re-post your question within the SAP Developer Center space, as someone there would be better placed to help you. This space is for questions, blogs, and discussions about SAP's training courses, certifications, and learning software.

    http://scn.sap.com/community/developer-center

    Good luck!

    Sarah

    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.