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!
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)
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
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.