Handline #Multivalue Error in SAP BO Webi report

SAPSAP WebiSAP BO

This error occurs when your formula returns more than one value and Webi report doesn’t know how to aggregate those values. This error occurs in below ways:

  • #multivalue in aggregation
  •  #multivalue in breaks header or footer
  •  #multivalue in section level.

Example:

Let us say an account number which is associated to more than one order numbers. Your solution will not work and hence you are seeing #MULTIVALUE “Multiple Order Numbers for the same account number”.

You can handle this by using an aggregated function as per your requirement like Max(),sum() or avg(). You can also check more details using this link:

https://archive.sap.com/discussions/thread/1919325


raja
Published on 19-Dec-2017 11:44:03
Advertisements