Truncated Average or Trimmed Mean in BEx

[former_member610230]

What is? рисунок1.png

I need to implement truncated mean using bex query designer. Please tell me, is it possible at all? Is it possible to do this using customer exit? It is a pity that query designer does not have this function. In Excel there is a function for this called TRIMMEAN. Thanks in advance. I wish you all good.

[former_member231709 · Accepted solution]

You can try to implement virtual keyfigure (BADI RSROA_OLAP_BADI) with your own logic.

https://wiki.scn.sap.com/wiki/display/BI/Virtual+Key+Figures+and+Characteristics