Multivale error

building reports webintelligence
1

Hi

I am getting the multvalue error while doing the below requirement.

I have main order number X, this X has different linked orders like x,y,z and their counts are different values.

When I pull these Main Order and linked orders these counts are displayed well, But I want to sum of all main orders.

Eg:

I have main order 1207475 , but this main order has linked orders 1207475, 1207856 and their case counts are 100,20.

Main Order Linked Order case count
1207475 1207475 100
1207475 1207856 20

but I removed the Linked order in the report, it shows the

Main Order case count
1207475 100
1207475 20

But I wanted to show the report like this

Main Order case count
1207475 120

gmoorthyp (BOB member since 2005-08-29)

2

HI Moorhty ,

You can solve this problem in two ways ;

  1. Using context operator at report level - Sum(Casecount IN( Main Order ))

  2. setting the sum as projection in Case count measure object

Regards
Swapnil

swapnil_taz :india: (BOB member since 2006-04-06)