Sintax ??? Type ??? I dont know...

[HERRERA]

Hi, i have a problem with a expression below....

Case
When [Union1].[Market Average]>=[Union1].[TOP 25%]
Then 1
Else  0
End

When i run the report just 0 appears.....

[MFGF]

Hi,

If you report both of these items, what gets displayed on your page?

MF.

[HERRERA]

Hi..

I need to count how many [Market Average] has value greater than [TOP 25%].

Tks

[kristysmith]

may be check your aggregate function???

[MFGF]

Hi,

Yes, but you didn't answer my question.  If you add both of these items to the report output then run, what values are you seeing displayed?

(ie are there any examples of [Market Average] being greater than or equal to [TOP 25%] in your query?)

MF.