Have the following scenario and need your advise or suggestions to resolve this issue.
Have a query where it displays the actual costs and quantities based on the material, different Cost Elements.
Need to manipulate (basically add) the quantities from the first cell of the report to the next cells (same quantity) for that material.
Here is the ex:
Data scenario before
Record# Material CostElemnt Actual Costs Actual output qty
1 100001 ------ ------ 2000
2 100001 1010A 1000.00 0
3 100001 1010B 2000.50 0
4 100001 1010C 9999.99 0
Data scenario After
Record# Material CostElemnt Actual Costs Actual output qty
1 100001 ------ ------ 2000
2 100001 1010A 1000.00 2000
3 100001 1010B 2000.50 2000
4 100001 1010C 9999.99 2000
I need to manupulate the data in the query level and how do I need to do. I have tried to figure out but could not. your inputs and suggestions welcome.
Hope there might be a way to use VBA code/ Variable or formula variable or some thing else to manipulate the query data while execution to get the report data after scenario.
Thanks
TNBW
Answer:
so you just want to repeat the value of row 1 in rows 2 -> 4?
if you're in version 3.0A or higher you can achieve this via the cell editor (read the online documentation on it and play around with it, it's fairly easy to use)
cheers,
El Belgio
Answer:
EL Belgio!! Thanks for your inputs.
Do I need to write code (Customer Exit) for this to manipulate from first row quantity to 2->4 records. Some how I could not able to set up the criteria for this. Am I missing some thing. Please share your inputs.
Thanks
TnBW