Doesn't work, already tried that way.

You any solution?

Ok, Thanks.

I got this:

=SWITCH

(

(Fields!Expr2.Value, "DataSet1") = 0, 0,

(Fields!Value.Value, "DataSet1") >= (Fields!Expr2.Value, "DataSet1"), 3,

(Fields!Value.Value, "DataSet1") / (Fields!Expr2.Value, "DataSet1") >= 0.7, 2,

(Fields!Value.Value, "DataSet1") / (Fields!Expr2.Value, "DataSet1") < 0.7, 1

)

It returns me an...

Thanks!

And what if there's more than one value in the value column?

For example: For Allocation I have at least 2 values (2 different funding sources).

Solutions for this example?

Great!

OK and about the changes I've done with 'Expr2'?

But I must be doing something wrong in the indicator state property with the colors expression.

Illuminate me here.

Thanks

Still doesn't work, I have this so far:

=SWITCH

(

LAST(Fields!Value.Value, "DataSet1") = 0, 0,

(FIRST(Fields!Value.Value, "DataSet1") >= LAST(Fields!Expr2.Value, "DataSet1")),3,

(FIRST(Fields!Value.Value, "DataSet1") / LAST(Fields!Expr2.Value, "DataSet1")), >= 0.7, 2,

(FIRST(Fields!Value.Value, "DataSet1") / LAST(Fields!Expr2.Value, "DataSet1")) < 0.7, 1

)

The...

OK thanks. But still not working.

Change of plan!

Table:

[valueType]|[Value]|[Expr1]|[Expr2]|[INDICATOR(4TrafficLights)]

[Allocation]|[3000000]|[ValuePlanned]|[5000000]

This way it may be easier, no?

With same conditions.

Can you write me the expression for this example?

Thanks!

OK, It is not working, but your suggestion brought me an ideia.

It is possible to use an indicator expression where - if the value from 'Textbox1'="Green" - show green indicator.

I'm...

Certainly the parenthesys have their importance here.

Could you check what you wrote above?

Thanks

Regards

2 Columns and a valueType has a respective value.

And what I need is to compare the value from allocation and the one from Value Planned.

Thanks H4K!

Lets say that I want to add in my tablix, a column : 'Allocation' where the data is in DATASET3. (Field: allocationvalue)

I'm trying to do as you said but,...

Can you show us the SQL code?

I had a similar problem, but what I wanted was to group 2 different fields, and all I had to do was to add...

Ok. I found a solution. Created a parameter(Name:ShowAll, DataType:Boolean, Visibility:Hidden, Default Values:False).

Added a textbox (Text:ExpandAll, Action:Go to report). Where users can click on, and all drilldowns expand.

And set the...

Thanks!

Already solved the problem! Thanks for the link Cazares, all usefull info.

Regards

Here's the result I get:

CAT NAME RESOURCES GROUPS

My Resource ...

Thanks. Works perfectly!

Regards