Skip to Content
avatar image
Former Member

sum of amounts based on period range in FAGLFLEXT

Dear Experts,

I have a requirement to add the amounts based on period range selected through selection screen. For examples in the the screen selection user selects Fiscal year , Fiscal Period_From and Period_To as

year ;2015

period_from: 001

period_to  : 008

then logic required is to sum the amounts HSL01 - till HSL08.

if user selects different range like period_from = 004 and period_to= 009 then sum (HSL04 till HSL09)

This logic is required to sum the amounts dynamically as user can select between 000 till 011. Please let me know how can this be done using graphical calculation view

Thanks in advance

pradyumna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 27, 2015 at 01:26 PM

    Hi Pradyumna, Do you use any report tools on HANA Views like business object Webi or Lumira? Webi or lumira aggregate the value automatically based on your input parameter. Thanks, Shakthi Raj Natarajan.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Shankthi, we are using webi as frontend tool. Does it handle the sum between the periods dynamically as i mentioned in the examples? user may select periods 2 to 8 or 3 to 9 from selection screen / / Thanks pradyumna

  • avatar image
    Former Member
    Sep 28, 2015 at 09:09 PM

    Hello Experts

    Does anyone have a better solution to achieve this with in graphical view or any SAP HANA VDM which has similar functionality. Thanks//

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      The value is not a calculated column, if u see I'm loading a sample data for year and fiscal period and value after creating a sample table.

      The formula mentioned is a filter expression which filters out the record required to be summed.

      for eg: If this is the input : Year = 2015 , period_start = 001 and period end = 005

      The formula is a filter expression as shown in the screen shot :

      ("YEAR" =$$IP_YEAR$$) and ("CC_CALC" >= '$$IP_P_START$$' and "CC_CALC" <='$$IP_P_END$$').

      -> First part would filter 2015 records ("YEAR" =$$IP_YEAR$$) from table.

      Second part would filter the HSL lines 001 to 005 ("CC_CALC" >= '$$IP_P_START$$' and "CC_CALC" <='$$IP_P_END$$').

      -> CC_CALC being calculated column  would contain values such as 1, 2 , 3 of corresponding HSL01, HSL02, HSL03 as it is being rightstr().


      -> resulting records are passed to aggregation box which does sum of values and gives the required output.

      If you follow the steps mentioned I believe you would arrive at the same solution.

      Regards

      -Anil

  • avatar image
    Former Member
    Oct 01, 2015 at 10:32 AM

    Hi Anil

    This solution may not work when I have HSL values like mentioned below. .. Pradyumna//

    Add comment
    10|10000 characters needed characters exceeded