Skip to Content
0

Cumulative measure in Hana Studio (Graphical Calcuation view)

Oct 25, 2016 at 11:55 PM

46

avatar image

Hi Friends,

Need your expert opinion. I am trying to create Calculation view (Graphicalview) in Hana Studio on Inventory report by using ECC tables MSEG and MBEWH (SLT / Side car approach).

I have a specific requirement to show inventory Quantity on daily basis (example: Day -1, Day-2, etc..) for a month as per the period and year entered by user in the selection screen of report. Based on Debit and Credit Indicator, I am calculating “Quantity In”, “Quantity Out” and “Net Quantity” (Quantity In minus Quantity Out) for each day using Calculating columns.As per the client requirement I need to show “Cumulative quantity” day wise, which means on the 1st day of month, I have to add Closing stock of previous month (Opening stock for current month) Plus Net Quantity of 1st day and for the2nd day, I need to add Net Quantity of 2nd day to the Day 1 cumulative quantity and so on for all calendar days of month.

Can you please assist how the functionality of Cumulative stock as mentioned above can be achieved in Graphical Calculation view?

Thanks...Karun

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers