Skip to Content
0

Design and Description for quarterly financial statement - SAP Bex reporting

Jul 26, 2017 at 05:55 PM

50

avatar image
Former Member

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!

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

2 Answers

avatar image
Former Member Jul 28, 2017 at 07:11 AM
0

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

Thank you

Yiannis

Share
10 |10000 characters needed characters left characters exceeded
Koen Hesters Aug 02, 2017 at 01:05 PM
0

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])

Share
10 |10000 characters needed characters left characters exceeded