Long time user, first time poster etc
I’ve been using Business Objects for nearly 2 years and we’ve recently upgrade to XI. When I first started we used 6.5 to extract data and run it all through Excel but the more I used BO I found it could do a lot, if not all, of the things I needed to do in Excel but automatically on the click of the refresh button.
I therefore try and make sure that any work that is replicated daily, weekly, monthly etc can be done in XI for ease and consitency.
I’m currently working on a quarterly piece of work which has perplexed me at the end.
Basically, I’m pulling back a months worth of data, with references, which normally contains around 750ish duplicates where a reference has 2 types of closure codes. So you can have:
Ref Closure Code Division
12345 3iii A
12345 3v A
54321 2 A
54321 3iii A
98765 3iii B
98765 4 B
The data is sorted in order of reference and then closure code so all duplicate references are grouped together and in order of the closure code. What I want to do is count the number of references per division where the closure code equals 3iii on the first line AND NOT the duplicate line.
I have created variable called duplicate which is:
If Previous([Incident Number]) = [Incident Number] Then “Y” Else “N”
And I have a summary sheet, which shows a summary for each division, which says: =Count([Incident Number]) Where ([Closure Code] = “3iii” And [Duplicate]=“N”)
This is where I became stuck. I get an error #MULITVALUE which I don’t get if I take the ‘AND [Duplicate]=“N”’ ut of the equation. I have also noticed that when I try and filter on the [Duplicates] variable it only allows me to filter on “N” and if I filter on “N” only the summary sheet doesn’t add up?!
Any thoughts or suggestions???
Marabellak (BOB member since 2010-04-21)
(BOB member since 2006-09-08)