Post reply

Ignore 0 in average

  • May 14, 2009 at 12:53 pm

    #204939

    Hi,

    I am new to SSRS2008. I wanna average a measure, non-zero values only, is there an easy way to do this?

    Thanks

  • May 15, 2009 at 5:46 am

    #995207

    Use IIF or something like this

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • May 19, 2009 at 1:48 am

    #996762

    pc4ads (5/14/2009)

    Hi,

    I am new to SSRS2008. I wanna average a measure, non-zero values only, is there an easy way to do this?

    Thanks

    Are you querying a Cube or a Database

  • May 19, 2009 at 1:56 am

    #996767

    Samuel Vella (5/19/2009)

    pc4ads (5/14/2009)

    Hi,

    I am new to SSRS2008. I wanna average a measure, non-zero values only, is there an easy way to do this?

    Thanks

    Are you querying a Cube or a Database

    Database

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

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