Conditional filter on calculated column not working

[dsg1]

Hi

I have a report where I have a value prompt (?status?) with static choices (red / yellow / green).

The list contains  Product , Revenue and Status columns.
Status field is calculated and shows red/yellow/green as text.
      - (case when Revenue >... then ('red') when Revenue...then ('yellow') else ('green') end)

I have to apply a filter condition on the Status column i.e. when red is selected in value prompt then [Status in ('red')] ...similarly for yellow n green.

the problem is when I am applying this filter on the calculated status column...I am getting either all of the record set or none.

Is there a way I can mention solve order or something which calculates the status column first and then apply the filter? (Note: I cannot create shortcuts to the queries)

Help needed

Thanks
dsg
   

[Lynn]

Is it a relational model? You could try setting the application property of the filter to "After Auto Aggregation".

Not sure about your syntax for the filter condition with the bracket after the condition and the value shown as you have it. I would think it should be [Status] in (?status?).

You will also want to make sure that the static choices exactly match the values being populated for your calculated column. Have you looked at results of the calculated column without filtering to see that it is set as you expect?

[dsg1]

Hi

I have already used the filter after auto aggregation....I am using dimensional data....is there any workaround other than the auto aggregation property where the solve order property can be used?


Thanks
dsg

[Lynn]

Oh dear....dimensional data....generally dimensional functions are the way to go.

You should search the forum. Here is one thread that gets into it.

http://www.cognoise.com/community/index.php/topic,18290.msg53568.html#msg53568