Skip to Content
0
Apr 15, 2014 at 12:29 PM

how to resolve #Multivalue Error

586 Views

HI All,

I have a data like below, in this for inpatient data is NULL and as per business requirement if data is null then "0". so i create a variable and drag into inpatient's total column

statement for inpatient is

=If IsNull([total]) Then 0 Else [total] Where ([items]="Inpatient")

items total

Office 4 Utilization 70 Inpatient

it is working and showing as "0"

but when inpatient has value it is showing #multivalue"

Office Visits 4 Non-Emergency ED Utilization 70 Inpatient Stays

40

how to resolve is issue

Please reply i am using SAP BO 3.1 INFOVIEW

Thanks in advance

Ranjeet