how to fix this variable

building reports webintelligence
1

I have to count the Customer number which has total current charges is more than ZERO

I created below formula but it is showing more Data than Expected.

=If([Query 3].[Total Current Charges]>0;Count([Query 3].[Customer Number]))

Thanks
Pooja

ktm :us: (BOB member since 2008-11-12)

2

On what basis are you suggesting that “it’s returning more than expected”?

Damocles :uk: (BOB member since 2006-10-05)

3

I have to show the Number of Customer which is Billable.To find the Billable Customer, we created a variable counting the Customer number whose Total Charges is more than ZERO.

If we matches the Number with our Existing Report it is not Accurate.In Existing report it is showing 1000.But in our report it is showing 1789.

I think my Variable is not right.

Thanks in Advance for your Help.

Pooja

ktm :us: (BOB member since 2008-11-12)

4

Try with the below formula
If (Count([Total Charges])>0) Then Count([Customer])

Hope it will help you

yalisis (BOB member since 2009-07-27)

5

I tried above mentioned formula also it is not working.

Thanks
pooja

ktm :us: (BOB member since 2008-11-12)

6

Are you just trying to get a total count? Try just returning a value of 1 then summing them up.

Sum(If (Count([Total Charges])>0) Then 1) )

See if that works.

CSGDrew :us: (BOB member since 2008-02-12)

7

Does the query to which you are comparing have the same criteria as this one? Or are you using this criteria in the belief that it should produce the same result?

Are there any other conditions on the other query that you may have overlooked?

Damocles :uk: (BOB member since 2006-10-05)

8

I created one variable called Count
code:-
=Count(If([Query 3].[Total Current Charges]>0;[Account Number]))

I want to get the Total of this variable when i did SUm i am geeting # CONTEXT at the end of the Column. How to get rid of this?

Thanks
Pooja
Pooja

ktm :us: (BOB member since 2008-11-12)