Skip to Content
avatar image
Former Member

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 multivalue_error 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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 14, 2016 at 12:29 PM

    Hi Nina,

    Try creating table using below columns

    OrderID

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

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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Divya,

      What a witty formula ! Counting Order_Id instead of Unit_id makes all the difference.Thanks a lot

      for the help !

      Cheers !

      Nina

  • avatar image
    Former Member
    Apr 14, 2016 at 10:20 AM

    Hello Nina,

    Please use this

    =Sum((If [Is_Accepted]="Y" Then 1 Else 0) In ([order_ID];[Unit_ID]))

    Regards

    niraj

    Add comment
    10|10000 characters needed characters exceeded