cancel
Showing results for 
Search instead for 
Did you mean: 

To display Fiscal Quarters below report title

former_member807458
Discoverer
0 Kudos

My quarter starts with Jan 1st to March 31 st

If I refresh report between January to March the As of date should come like 01-01-2022 to 03-31-2022

If April then it should populate 04-01-2022 to 06-30-2022

jerryjanda
Community Manager
Community Manager
0 Kudos

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Secondly, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

Finally, I recommend putting a bit more detail in your question. As it stands, you don't explicitly ask a question, so I'm not sure if our members will be able to assist you.

Should you wish, you can revise your question by selecting Actions, then Edit.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

--Jerry

Moderation Lead

Accepted Solutions (0)

Answers (1)

Answers (1)

ayman_salem
Active Contributor
0 Kudos

In the Webi report, define the following variables:

v_Q: =Quarter(CurrentDate())

v_FDayOfQ: =ToDate((([v_Q]-1)*3+1)+"-"+"01-2022"; "MM-dd-yyyy")

v_LDayOfQ: =LastDayOfMonth(RelativeDate([v_FDayOfQ]; 2; MonthPeriod))

...

hope this is what you are looking for

ayman_salem
Active Contributor
0 Kudos

I hope this is what you are looking for and it helps
If you are okay with the answer, please accept and close it.