Sorry I had to repost this question.. The expert replies to me at 3 am my time everynite and by the time i reply i have to wait till 3 am the next day for a reply, this will take a week..
I have a margin % field. I need 2 if statements, One that Looks at the Margin % and if it over 50% change it to 50% or if it under 0% change it to 0%
then i want a if statment that if it is changed, make it red..
I used This
=IIF(Fields!Margin.Value > 50,50,IIF(Fields!Margin.Va
lue < 0,0,Fields!Margin.Value))
but it did nothing (see how it wont move the percent down to 50 if its over 50.. it just shows the same number
Now the margin field I made and caluclated using two other data sets .. and formated with p (for percent)