Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

To resolve a #MULTIVALUE error

Hi everyone,

I have 4 objects in a report, say, Order_id, Unit_id, Is_Accepted (either Y or N), Count_Accepted.

I need to count number of accepted units for a particular order. But when I am using the formula:

Count_Accepted=If ([Is_Accepted])="Y" Then Count([Unit_id])   ,


I am getting a for all those orders which have both accepted & unaccepted units for them, unlike those orders which have either all Y values or all N values of Is_Accepted for all the Unit_id.

I have tried ForEach & ForAll and also feel aggregation isn't the key here.

So can anyone provide a resolution for this error ?

Much thanks in advance.

Tags:
Former Member
Former Member replied

Hi Nina,

Try creating table using below columns

OrderID

Count([OrderID];All) Where ([Is_Accepted]="N")

Count([OrderID];All) Where ([Is_Accepted]="Y")

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question