Skip to Content
avatar image
Former Member

Design and Description for quarterly financial statement - SAP Bex reporting

Hi All,

We have a requirement in where financial quarterly statement should be designed as follows. The design and display for a single column should be changed as,

1) When the 0FISCPER3 selection is 3, data from only Jan to Mar should be displayed and label should be Q1.

2) When the 0FISCPER3 selection is 6, data from only Apr to Jun should be displayed and label should be Q2.

3) When the 0FISCPER3 selection is 9, data from only Jul to Sep should be displayed and label should be Q3.

4) When the 0FISCPER3 selection is 12, data from only Jan to Dec should be displayed and label should be Q4.

For description - Is fiscper3/3= Q1, 6/3 = Q2... possible with variables without exit?

Is there any way to achieve above conditions without customer exit? Kindly help me with your thoughts.

Thanks in advance!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 28, 2017 at 07:11 AM

    Dear Ajantha, since you want to keep it simple i suggest you to create four different variants for the selected periods.

    Thank you

    Yiannis

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 02, 2017 at 01:05 PM

    Hi,

    yes you can

    create a formula variable -> input (call it fiscQUArter) if you just want to use (1,2,3,4) as the 4 quarters or (3.6.9.12) it is up to you

    create a calculate keyfigure along your fisccariant (I used K4)->

    (formulevariable>=3)*([Jan]+[feb]+[mar])

    +

    (formulevariable>=6)*([apr]+[may]+[jun])

    +

    (formulevariable>=9)*([jul]+[aug]+[sep])

    +

    (formulevariable>=9)*([dec]+[nov]+[oct])

    Add comment
    10|10000 characters needed characters exceeded