To resolve a #MULTIVALUE error
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 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.
Try creating table using below columns
Count([OrderID];All) Where ([Is_Accepted]="N")
Count([OrderID];All) Where ([Is_Accepted]="Y")