Saturday, February 25, 2012

Q:conditional formating

Hello,
I am trying to color negative detail lines with the following.
=iif((Fields!Amt1.Value-Fields!Amt2.Value)<0,"Red","Black")}
It is working if the value is not zero. Some 0.00 values are black but some
of them are red. What is problem?
Jim.Hi Jim
I think the problem is because you haven't specified the text color for
the result value zero.
You can try specifying the condition as "<=0" if you want the zero
values in red like
=iif((Fields!Amt1.Value-Fields!Amt2.Value)<=0,"Red","Black")
Else if you want zero values in black you can try
=iif((Fields!Amt1.Value-Fields!Amt2.Value)>=0,"Black","Red")
Hope this solves your problem
Regards
Prathima.C
JIM.H. wrote:
> Hello,
> I am trying to color negative detail lines with the following.
> =iif((Fields!Amt1.Value-Fields!Amt2.Value)<0,"Red","Black")}
> It is working if the value is not zero. Some 0.00 values are black
but some
> of them are red. What is problem?
> Jim.|||I did that but it did not change anything. Some of zeros are blank, some are
red. Is there any precession issue?
"prathima.chandramouli@.gmail.com" wrote:
> Hi Jim
> I think the problem is because you haven't specified the text color for
> the result value zero.
> You can try specifying the condition as "<=0" if you want the zero
> values in red like
> =iif((Fields!Amt1.Value-Fields!Amt2.Value)<=0,"Red","Black")
> Else if you want zero values in black you can try
> =iif((Fields!Amt1.Value-Fields!Amt2.Value)>=0,"Black","Red")
> Hope this solves your problem
> Regards
> Prathima.C
>
>
>
> JIM.H. wrote:
> > Hello,
> > I am trying to color negative detail lines with the following.
> > =iif((Fields!Amt1.Value-Fields!Amt2.Value)<0,"Red","Black")}
> > It is working if the value is not zero. Some 0.00 values are black
> but some
> > of them are red. What is problem?
> > Jim.
>

No comments:

Post a Comment