Post reply

How to get difference of two running value columns

  • May 5, 2009 at 12:35 am

    #204272

    Hi,

    i have a report, which is having a matrix showing results fro two parameters.

    Test1 Test2

    noOfCalls NoOfCalls

    12 24

    20 30

    I want to add a new column

    Test1-Test2

    NoofCalls

    12

    10

    if some one can help please.

  • May 5, 2009 at 12:59 am

    #988572

    Use

    =Fields!Test1.Value-Fields!Test2.Value in the expression of thrid column.

    Hope this will help you

    Waiting for your test result

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

    Thanks,
    Arunkumar S P

  • May 5, 2009 at 2:26 am

    #988603

    there is no field like Fields!Test1.Value and Fields!Test2.Value.

    I have a parameter RUNID

    in query

    runid in(@runid1,@runid2)-- matrix report is getting genertaed on this basis.

    test1 for runid1 and test2 for runid2

    and the field is Fields!NumberOfCalls.Value

    whose running difference i want.

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

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