Carry over end results of one column to another

[Former Member]

Hi all,

I am now creating a BEx Query and need to carry over the results of a calculated key figure "Net Position of Material" to the Restricted Characteristic  "Inventory of Hand" of the next week column (so on for all weeks showing).

Any suggestions how this can be done in BEx?

Regards,

Daniel

[Former Member · Accepted solution]

hi,

define " inventory on hand as"  : net position for material and restrict it with cal week -1

Note: you need to enter cal week from selection screen. if your report need to display cal week for a month/quarter.. then you need to write an exit to get the range of cal weeks from the user input screen.

[Former Member · Accepted solution]

Hi Jyothi,

Thank you for your input. I did like you suggested but the Net Position for Material results don't move to the next column but show on the same column(shown in red). Blue marks show how the results should move.  Please advise.

I

[Former Member · Accepted solution]

Hi Daniel,

in your first image.. net position is 200, 000 /300,00/400,00 for 11.2016/12.2016 and 13.2016..

the values which are showing in inventory on hand seems to be correct when comparing to previous screen shot.

however net position values also seems to be displaying as calweek-1??

Net position of material should be on calweek/year and inventory on hand should be calweek-1

what is the input selection of your report? and how many cal weeks do you need to show in report?

[Former Member · Accepted solution]

Solved it using cell definitions in the Bex Analyzer.

[former_member251664]

change columns to rows. your required positions.