Standard Deviation

[KHK]

Hi,

=IFERROR(STDEV.P(BQ14348:CB14348)/AVERAGE(BQ14348:CB14348),0)

Could please let me know how to convert above "STDEV.P" excel function in Incorta. 

[mhornak]

Hello All,

thank you for your advice. I would ask one question regarding that.

I was able to calculate abs(x - average(x))*abs(x - average(x)), but in next colum I would get sum of these row and there are not correct numbers.

I was using formula below like Sum with Group by, but it does not calculate correctly.

sum(

    (abs(

        sum(

            ds_AmaGIzL8G.insight.quantity, 

            groupBy(

                ds_AmaGIzL8G.insight.code, 

                ds_AmaGIzL8G.insight.branch_code, 

                ds_AmaGIzL8G.insight.DIV2, 

                ds_AmaGIzL8G.insight.Weeknum_Cube

            )

        ) - sum(

            ds_AmaGIzL8G.insight.quantity, 

            groupBy(

                ds_AmaGIzL8G.insight.code, 

                ds_AmaGIzL8G.insight.branch_code, 

                ds_AmaGIzL8G.insight.DIV2

            )

        ) / 6

    ) * abs(

        sum(

            ds_AmaGIzL8G.insight.quantity, 

            groupBy(

                ds_AmaGIzL8G.insight.code, 

                ds_AmaGIzL8G.insight.branch_code, 

                ds_AmaGIzL8G.insight.DIV2, 

                ds_AmaGIzL8G.insight.Weeknum_Cube

            )

        ) - sum(

            ds_AmaGIzL8G.insight.quantity, 

            groupBy(

                ds_AmaGIzL8G.insight.code, 

                ds_AmaGIzL8G.insight.branch_code, 

                ds_AmaGIzL8G.insight.DIV2

            )

        ) / 6

    )), 

    groupBy(

        ds_AmaGIzL8G.insight.code, 

        ds_AmaGIzL8G.insight.branch_code, 

        ds_AmaGIzL8G.insight.DIV2

    )

)

Please could you help me, what could be wrong?

Many thanks.

[JoeM · Accepted solution]

@mhornak - 

Are you grouping by the following in your aggregated table insight? Also, to be safe, change the aggregation method to formula.

                ds_AmaGIzL8G.insight.code, 

                ds_AmaGIzL8G.insight.branch_code, 

                ds_AmaGIzL8G.insight.DIV2

[mhornak]

Many hanks, I was not aware that grouping in insight has impact on this calculation.