Counting a Measure Split by A Week Dimension

building reports webintelligence
1

Hello chaps,

I have a Measure called [Value of Credits], I want to count each instance where it’s greater then zero in a table with the column header of Week.

Seems easy enough… But

No matter how many different ways I’ve tried I can only get it to return either 1 of 17 (The total number of weeks??)

Any ideas?

:hb:

Thanks

Mike

mikeyhebble (BOB member since 2009-04-28)

2

create an Alerter where [value of credits] > 0.

Or

Create a variable : Var1= ([Value of credits] >0 In Report) and place it in report.

Thanks

BOCP (BOB member since 2007-07-02)

3

Hello!!

Thanks for your help…

Building the “Var1= ([Value of credits] >0 In Report)” variable is still only returning a 1 for each week???

mikeyhebble (BOB member since 2009-04-28)

4

Try this::

 Var1= Count([Value of credits] >0 In Report)

Thanks

BOCP (BOB member since 2007-07-02)

5

Ooooo that’s close… It’s still counting the £0.00 value’s though??

Does it make a difference if it’s £0.00 and not 0 ??

mikeyhebble (BOB member since 2009-04-28)

6

Nope. Difference is currency symbol and decimal precision.

That’s it…

where you struct??

Thanks

BOCP (BOB member since 2007-07-02)

7

Was I struct?? Sorry I’m not sure what that means?

It’s still counting the 0, it should return 13 (One shows as £0.00) but I’m getting 14 so it’s still counting it???

I have improved to a count now though from a 1 or 17 result which is all I could get!?

:smiley:

mikeyhebble (BOB member since 2009-04-28)

8

Are you getting £0.00 from object itself ? or after changing properties of that variable??

Thanks

BOCP (BOB member since 2007-07-02)

9

Value of Credits is straight out of the universe, not in a variable defined by myself.

It comes out formatted as £0.00

mikeyhebble (BOB member since 2009-04-28)

10

Try to change the measure to number like 0(Zero) for that create one variable with same measure, once you done. Apply formula based on this, after that change the format to bring back to “£0.00”.

Hope it will help …!!

Thanks

BOCP (BOB member since 2007-07-02)