03-14-2023 07:56 AM
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.
Solved! Go to Solution.
10-30-2023 01:19 AM
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.
11-03-2023 06:49 AM
@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
11-09-2023 04:20 AM
Many hanks, I was not aware that grouping in insight has impact on this calculation.