Query object have null value in boolean variable

[dlafrance]

Hi,

I am struggling with a weird problem...

I have a crosstab with a line that show the % of accomplishment of a project. I want that the column be highlighted in gray if it's 100%. No big deal, i have made this before..

My problem is that when I try to check if [Query1].[%Achievement] = 100, it always return false. if I check [Query1].[%Achievement] is null, it always return true.

Hope you can help me on this problem.. Thank you all for your time!

[Gopinath]

I think you should use the actual value in the condition like

[Query1].[%Achievement] = Value

instead of

[Query1].[%Achievement] = 100

becuase 100% might be the display value for the field(set in Data format)

[dlafrance]

thanx gobinath for your answer.

My problem is not to compare with a certain value or not (like compare to 1), my problem is that it is always null, even if i display the values in my crosstab.

Thanx

David

[Suraj]

Your issue may be different level of aggregation.
Crosstab intersections are not just one data item, it is a cross-section of columns and rows.
If you want to use that in a variable, create a data item using tuple() function that gives same data in your crosstab and then use that data item for comparison purpose.