I’m having a really odd problem. (Webi XI R2). I have a data provider returning [Job ID]'s entered on our system in a week. I create a measure called [Entered] in my report which is just =Count([Entered].[Job ID]). That measure is of type ‘number’. This is one of two queries/data providers in my report hence the [Entered].[Job ID] bit - I have another query called Completed that contains Job IDs that were completed.
I’ve created a simple crosstab report with East/West area names in the vertical data bit (on the left) and sub area numbers in the horizontal bit on top and dropped in [Entered] as the value.
This is the confusing bit. I right click [Entered] value and insert a sum row and column (all this as per my attachment). Now, the formula for that sum of [Entered] is obviously just =sum([Entered])…
Now, I want to insert a formula in a second row (currently blank in attachment) which I want to get me the % each figure is of the total in the week.
Easy??? Is it rubbish! I can’t get webi to treat [Entered] as a number measure. I originally tried to start writing my formula by writing =[Entered]/sum([Entered]) in ([Area]) in my blank row but that came up with the WIS 10037 error… So I tried doing simpler things and can’t even enter =sum([Entered]) in the cell without getting the same error which is a bit bonkers because that’s obviously the formula in the bottom footer row of the table = / !
Anyone any idea what’s going on and if it’s something I can get around? (Yes I know that I should use a measure brought from the universe as my count but it’s a small report, and when I finish it I need to give a list of certain jobs in another tab.)
Thanks in advance!
– Edit –
Just one last quick thing - I’ve also tried wrapping the formula in the Entered measure in tonumber() to double force it to be recognised as a number, but also to no avail…
This is not really making sense. It should work. I assume the cells on the left are merged cells? What is in the Contrived Area >>>" cell?. Maybe it doesn’t like that you named a variable the same name as a query?
Thanks
The Contrived Area>>> is just text entered into a cell. The cells with East and West in them are merged.
I did manage to get this to work yesterday but only by creating a new variable called [Entered Percentage in Team] which gave me
=Count([Entered].[Job ID])/Sum(Count([Entered].[Job ID])) In ([Team])
That works, however what I was originally trying to do should have worked. I wonder if you’re right about naming a variable the same name as a data provider? How can that be an issue when a report level variable quite clearly should be at a different hierachical level in the document that the data provider… VB doesn’t have this kind of issue!
Very strange!
PS - I changed what I wanted out of the report and switched to wanting percentage in Team, not Area; I got the same original WIS error either way.
A couple of things, could it be your IE version or Java. I know I sound like a broken record, but this can be the cause of so many issues, its untrue?
Did you try a running sum, with a break dimension, on Area?
Everything else works with it. Breaks functioning properly, runningsums, counts footer and header sums etc (I dunno what you call the column to the right of the table when you sum or count a variable in a crosstab, I know it’s not a header but at 8:45 and with minimal caffeine that’s the best I’ve got).
I’m on IE7 version 7.0.5730.13, Java 2 Standard edition v 1.4.2_04 from back in the day in 2003… hmm… makes you wonder but this really should be quite straight forward no matter surely.
Anyway, I’ve got round the issue as mentioned quite easily really but I was just taken aback a little by getting the error in the first place.
I had similar issue with wis 10037. I could not get multiplication or division to work.
My issue was that both query and measure were named Transactions. After changing the measure name to Transaction1 everything worked. Lesson learned: Queries are objects as well and can be manipulated or referenced in formulas
/ 
!
(BOB member since 2009-11-02)
(BOB member since 2009-08-28)
(BOB member since 2009-11-02)