Skip to Content
0
May 24, 2016 at 07:37 AM

Can anyone help me with a formula for RunningSum?

135 Views

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

Attachments

Mat1.jpg (62.2 kB)
Mat2.jpg (49.8 kB)
CFK.jpg (70.2 kB)