Skip to Content
0

Week Number in a Quarter in WebI

Jan 05 at 10:02 AM

79

avatar image

Please suggest me how to get week number in a quarter in Webi or in Unvierse.

Thanks,

Praveen G

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

4 Answers

Jason Everly
Jan 05 at 08:14 PM
0

Hi Praveen,

Go check out this thread, it may be helpful.

https://archive.sap.com/discussions/message/14470799#14470799

Jason

Share
10 |10000 characters needed characters left characters exceeded
Praveen Guntuka Jan 11 at 01:01 PM
0

Thanks Jason!

I checked the above solution before posting my thread. I am looking for a single formula to fetch the current week number in a Quarter.

Is if possible to fetch using a single formula?

--Praveen G

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi,

note that the formula below is only to use when your data is weeklybased and you are only reporting weeknumbers.

=if [Week] inlist(1;2;3;4;5;6;7;8;9;10;11;12;13) Then "Q1" Elseif [Week] inlist(14;15;16;17;18;19;20;21;22;23;24;25;26) Then "Q2" Elseif [Week] inlist(27;28;29;30;31;32;33;34;35;36;37;38;39) Then "Q3"Else "Q4"

0

Hi Koen,

Thanks for your reply.

I am looking for Week Number in a quarter.

If the date is April16th 2018 then it should display 3 (week number in a quarter)

Thanks,

Praveen G

0

=13-(Quarter([Date])*13-Week([Date]))

gazo1.png (4.0 kB)
0
Erdem Pekcan Jan 16 at 12:20 PM
0

Hi,

There's no single function to to calculate the week in a quarter base instead of year.
If you have all weeks as a data source, you may try to rank the weeks and use quarter as a reset dimension.

Regards,
Erdem

Share
10 |10000 characters needed characters left characters exceeded
Praveen Guntuka Feb 09 at 05:18 PM
0

I have tried with Ceil(Daysbetween (qtr start date and end date)/7)

Using the above function I am able to display week number in a quarter.

Thanks,

Praveen G

Share
10 |10000 characters needed characters left characters exceeded