Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jessica M. Moss Designing a Dashboard - Level 6 in the Stairway to Reporting Services RE: Designing a Dashboard - Level 6 in the Stairway to Reporting Services

  • March 25, 2013 at 3:54 pm

    #1600553

    I Love the SIGN function...

    CASE WHEN fsq.SalesAmountQuota > frs.SalesAmount

    THEN 1 ELSE CASE WHEN fsq.SalesAmountQuota = frs.SalesAmount

    THEN 0 ELSE -1 END

    END as Trend

    Can be replaced with:

    SIGN(fsq.SalesAmountQuota - frs.SalesAmount) as Trend

    IMNSOH, I think it is simpler 🙂