 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?

(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%
10|10000 characters needed characters exceeded

### Related questions

• 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