Post reply

Comparing negative number for conditional formatting

  • April 19, 2012 at 6:51 am

    #259630

    I'm trying to use variance (or % of change really) to do conditional formatting on a report. So if the % of change is a negative number greater than -15% then format Red, else format Grey. But it doesn't seem to be working properly. Any ideas what I'm doing wrong?

    =IIF(Fields!WedVar.Value < -15,"Gray","Red")

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

  • April 19, 2012 at 6:55 am

    #1475983

    Is your value Fields!WedVar.Value just formatted as a Pct, or is it stored as a pct. You may have to use -.15

  • April 19, 2012 at 7:07 am

    #1475989

    Haha, that was it exactly! Too early in the morning for that 😉 And my formatting was backwards. Thanks!

    Owner & Principal SQL Server Consultant
    Im Your DBA, Inc.
    https://www.imyourdba.com/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply