Can anyone help me with a formula for RunningSum?

[Former Member]

Hi experts,

I have an issue with my report when I use RunningSum on two BEx reports using calculated key figures.

The same report works fine for quantity, but using the same formula and replace the quantity with value and remove the material dimension the formula doesn't display the correct value.

The version of SAP BO is (SAP BusinessObjects BI Platform 4.1 Support Pack 5 Patch 3 Version: 14.1.5.1606) .

The formula is: =RunningSum([QuantityStock$]+[NetDemand$]-[Requirements$];([Material - Key];[MRP Characteristic - Key]))

After I remove the Material the sum of two materials is wrong calculated. I think when I remove the Material dimension the standard cost is calculated as a sum and then multiply with the total quantity which is wrong.

Any suggestion is welcome.

Thanks Gabriel

[Former Member · Accepted solution]

Hi,

Ideally when you remove the Material Dimension from the Cross Tab it should automatically aggregate the Key Figures based on the default Context of the block i.e. MRP and Date dimension(005.2016 etc.).

What is the aggregation at BEx level for those Key figures?

Regards

Niraj

[Former Member · Accepted solution]

Hi Niraj,

It's abit strange because when I use the same formula but only quantity the output was ok. Then I try two ways, one I calculate the quantity*standard cost at BEx level without any success and also I try it on Webi to calculate the Quantity* Standard cost.

The calculated key figure in Query designer has no aggregated, it's set-up as standard aggregated.

[Former Member · Accepted solution]

Can you try that in a vertical Table having just MRP ,Date dimension(005.2016 etc.) and then one by one try adding up individual Key figures and finally in the last do your calculation in a separate column.

This will help us to understand where the things are going wrong.

Regards

Niraj

[Former Member · Accepted solution]

I add all the measures in order to have a better visibility.

In this picture the formula is ok when I have the material in the block.

After I remove the Material the formula doesn't display the correct value.

[Former Member · Accepted solution]

Hi,

After I deleted the report and I create a new from scratch now all the data are calculated ok.

I apply the next formula:

=Sum(RunningSum([QuantityTotalStock$]+[NetDemand$]-[Requirements$];([Material - Key[)) ForEach([Material - Key]))

Thanks a lot for your valuable input.

[amitrathi239]

try this.

=RunningSum(([QuantityStock$] foreach ([Material - Key]) +[NetDemand$] foreach ([Material - Key]))-[Requirements$] foreach ([Material - Key]);[MRP Characteristic - Key])

[Former Member]

Hi Amit,

I try your formula  but doesn't display any data.