Average of Aggr result not showing the correct result

[Cascader]

hi 

I have the following expression that I implement aggregation function on result of Aggr

    Avg(

        Aggr(           

            AVG({<MC.isLastWorkDay={'1'},Team={'A'}>} IF(OnTarget >= Target, 1, 0)),

             ProductGroup

        )

    );

 the following example:

ProductGroup              OnTarget

------------------------------------------------

P1                                              1

P2                                              1

P3                                              0

I supposed to get .67 but I'm getting other result 

[stevejoyce]

Try below update:

Avg({<MC.isLastWorkDay={'1'},Team={'A'}>}

        Aggr(           

            AVG({<MC.isLastWorkDay={'1'},Team={'A'}>} IF(OnTarget >= Target, 1, 0)),

             ProductGroup

        )

    );

[Cascader]

still return the same result!

[stevejoyce]

Ok, can you post sample data and/or screenshot?

I guess if i were to do the calculation I would do this, you can try...

=Count({<MC.isLastWorkDay={'1'},Team={'A'}, ProductGroup = {"=OnTarget>=Target"}>} ProductGroup)

/

Count({<MC.isLastWorkDay={'1'},Team={'A'}>} ProductGroup)

[Cascader]

this is the data, I'm supposed to get 0.8 as result but i'm getting 0.4375

[stevejoyce · Accepted solution]

so this below would be the equivalent of what your table shows:

Avg({<MC.isLastWorkDay={'1'},Team={'A'}>}

        Aggr(           

            If(AVG({<MC.isLastWorkDay={'1'},Team={'A'}>} OnTarget) >= Target, 1, 0),

             ProductGroup

        )

    );