May 19, 2016 at 1:06 am
For the following below example how to I achieve the conditions as underneath and color code as underneath.
Table:Column names)
ServerPCPULCPUTF
A 121 --->Red
B 222 --->Green
C 334 --->Red
D 236 --->Green
First condition:
For any Server only if TF is always less than 8---->Green else Red
For Server A if LCPU = TF and TF < 8 ---->Green else Red
For Server B if LCPU = TF and TF < 8 ---->Greenelse Red
For Server C if PCPU = 0.5*TF and TF < 8 ---->Green else Red
For Server D if LCPU = 0.5*TF and TF < 8 ---->Green else Red
I tried this but it is throwing an error:Operator= is not defined for types.
=IIF(Fields!TempDataCounts.Value<8,"Green",
iif(Fields!Server.Value="A" and Fields!LCPU=Fields!TF, "Green",
iif(Fields!Server.Value="B" and Fields!LCPU=Fields!TF, "Green",
iif(Fields!Server.Value="C" and Fields!PCPU=0.5*Fields!TF, "Green",
iif(Fields!Server.Value="D" and Fields!LCPU=0.5*Fields!TF, "Green",
"Red"))))
May 19, 2016 at 3:22 am
Don't totally understand your question but your probably looking for the switch statement in an expression in the required area. Basic example below:
=Switch
(
Fields!YourField.Value < 8, "Green"
,Fields!YourField.Value > 8, "Red"
)
May 30, 2016 at 3:47 am
Please check the data type of the fields on which "=" operator is used. Both fields must have the same datatype.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply