Please suggest me how to get week number in a quarter in Webi or in Unvierse.
Thanks,
Praveen G
Hi Praveen,
Go check out this thread, it may be helpful.
https://archive.sap.com/discussions/message/14470799#14470799
Jason
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
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"
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
=13-(Quarter([Date])*13-Week([Date]))
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
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