Skip to Content

Week Number in a Quarter in WebI

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

Thanks,

Praveen G

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 05 at 08:14 PM

    Hi Praveen,

    Go check out this thread, it may be helpful.

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

    Jason

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11 at 01:01 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 16 at 12:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 09 at 05:18 PM

    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

    Add comment
    10|10000 characters needed characters exceeded