Post reply

average of average getting worng in matrix.

  • October 4, 2012 at 6:50 am

    #263403

    EFF

    MTDPrev MonthCUR WKPrev WeekPrevWeekMinus1

    79%78%79%78%79%

    50%53%48%48%50%

    22%29%20%22%23%

    69%70%68%69%69%

    Totalavg63%65%63%63%64%

    76%16%78%76%75%

    81%82%83%82%81%

    53%0%57%55%50%

    94%56%92%89%106%

    Totalavg82%48%82%81%86%

    83%81%82%82%83%

    Totalavg83%81%82%82%83%

    grantavg80%61%80%79%82%

    hi

    when i am avg() function in matrix the avg in the second level and third level generates the error..

    check you check the values above .

    give the suggestions..

    thankfull

    savam

  • October 4, 2012 at 8:08 am

    #1545560

    What error are you getting?

  • October 5, 2012 at 7:29 am

    #1546068

    total averages and grand total avarages are wrong values

    yaa r

    anybody help me ..

  • October 9, 2012 at 7:01 am

    #1547201

    any body help me

    i am still suffering with the same issue ..

    i have 4 row gruops ans 2 columns groups

    and avg(field.value)

    when i will calculate the total and grand total i got wrong averages plz take a look of above values .

    howto solve this situation..

    thanks

    sarvam

  • October 9, 2012 at 7:06 am

    #1547204

    how are u calculating the values , have you looked up semi additive measures.

    Edit :- when asking for help , it would be better if you can provide nicely formatted data and any logic your currently using so that others understand the context in which your asking the question.

    Jayanth Kurup[/url]

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

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