Week Number in a Quarter in WebI

[former_member203168]

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

Thanks,

Praveen G

[former_member203168]

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

[erdempekcan]

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

[former_member203168]

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

[kohesco]

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"

[former_member203168]

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

[kohesco]

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

[former_member184995]

Hi Praveen,

Go check out this thread, it may be helpful.

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

Jason