1671762 - How report Conditions can affect the report result.

This document is intended to explain some scenarios in which a condition, in a Web Browser report, can restrict the result area of a report and affect its results.

Some possible scenarios:

1. You face a difference in the Total result of the Sales Order Volume report. 

• With a specific User you noticed that the result of the Sales Order Volume report changes when you switch among the Sales Order Volume by Account and the Sales Order Volume by Origin view. 
• In this case you also noticed that some Accounts are missing when choosing the Sales Order Volume by Account view.
• When you switch to the Sales Order Volume by Origin view the results, like the Net Value Total, are correct and the missing Accounts are also visible. 

2. You face a difference in the documents and Total result shown within the Total Spend per Spend Category report.

• With a specific User (X) you noticed that some values of the Total Spend per Spend Category report changes when you switch among the Top 10 Suppliers by Spend Category view and standard or custom created views.
• In this case you also noticed that some Suppliers and Invoice ID are missing when choosing the Top 10 Suppliers by Spend Category view.
• When you switch to some of the standard views, like the Maverick Spend per Month, you can see that all the Suppliers are visible and the result shown is the correct one. 

The report behavior is as designed. The cause of these changes in the report result may be that the view you are using has some conditions attached to it.

In these two scenarios the reason of having a different outcome on the result data and result is due to the conditions attached to the used views.

Scenario 1:

The Sales Order Volume by Account view, from the Sales Order Volume report, is based on a Ranked Condition which restricts Net Values key figure to the Top 10 Accounts. For this reason you will notice that some Accounts are missing and consequently the total result is affected.

Scenario 2:

The Top 10 Suppliers by Spend Category view, from the Total Spend per Spend Category report, is based on a Ranked Condition which restricts Total Spend key figure to the Top 10 Suppliers by Total Spend. For this reason you will notice that some Suppliers are missing and consequently the total result is affected.

In these two cases, to view all the data without restrictions, you can modify the condition settings and remove the restriction as following:

1. Click on the Key Figure (arrow) to show the Context menu.
2. Select Manage Conditions from the list.
3. Adjust condition settings.

For further information on the Conditions functionality you may refer to the Help Center. 

KBA , sales order volume , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To