Skip to Content
avatar image
Former Member

Cumulative measure in Hana Studio (Graphical Calcuation view)

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?


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers