Post reply

Sum the values of an expression

  • June 15, 2012 at 7:37 am

    #271420

    Hi all,

    I want to sum the values of an expression. The expression generated 1(s )and 0s but I want to sum the 1(s)

    I wrote Sum(iif(Fields!digi.value =1)). But the expression is not working. I tried again Sum(iif(fields!digi.value = 1, 0)) . Still not working. I need help

    EM

  • June 18, 2012 at 7:30 pm

    #1502547

    eobiki10 (6/15/2012)

    Hi all,

    I want to sum the values of an expression. The expression generated 1(s )and 0s but I want to sum the 1(s)

    I wrote Sum(iif(Fields!digi.value =1)). But the expression is not working. I tried again Sum(iif(fields!digi.value = 1, 0)) . Still not working. I need help

    EM

    If you have only 1s and 0s and just want to sum the 1s, just sum the field - no logic needed. Sum not Count!

    (1 + 1 + 1 + 0 + 0 + 1) = (1 + 1 + 1 + 1)

    =Sum(Fields!digi.value)

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]

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

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