Post reply

How to subtotal an expression

  • January 5, 2018 at 8:33 am

    #402804

    I have a column, Column3,  that has the expression =iif(Fields!ARR.Value=1, Fields!COLL.Value,0). Is it possible to sum this expression in the group footer? If so, how?

  • January 5, 2018 at 5:43 pm

    #1974789

    NineIron - Friday, January 5, 2018 8:33 AM

    I have a column, Column3,  that has the expression =iif(Fields!ARR.Value=1, Fields!COLL.Value,0). Is it possible to sum this expression in the group footer? If so, how?

    Probably the easiest way is to add a Calculated Field to your dataset, and then you can use that expression to calculate its value. Then the field can be summed in the footer.

  • January 9, 2018 at 4:07 am

    #1975045

    Thanx.

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

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