#mutivalue error message

building reports webintelligence
1

How can I get rid of this #MultiValue error? This is what my data looks like

Order Item CostCategory UnitPrice
20305060 24385 Labor 1.00
0305060 24385 Other 3.00

I need my report output to be like this.
Order Item LaborCost OtherCost
20305060 24385 1.00 3.00

I am using these two formulas
if (CostCategory=“Labor”) sum(UniPrice) else 0
if (CostCategory=“Other”) sum(UniPrice) else 0

2

Are both Order Items meant to be the same?

3

They could be different

4

So how have you decided to just display the one on the Labor row?

5

Actually I am merging two universes by order number, I want to summarize both costs and always rolled them to the record order/item in the primary universe. There is a one to many relationship between the two universes.

6

In that case, use logic of
=Sum(If(CostCategory=“Labor”)) instead of =If(Sum())
or
=Sum(x where (CostCategory=“Labor”))