Skip to Content
author's profile photo
Former Member

Days between month

Sep 05, 2014 at 01:06 PM | 7 Views

Hi ,

I have requirement to have Days between month should be in following format

Days 0-7 8-15 16-22 23-29

1 9 18 24

3 12 22 28

=If([ number]=0)Then("0-7") ElseIf([ number]Between(8;15))Then("8-15")

ElseIf([ number]Between(16;22))Then("16-22")ElseIf([ number]Between(23;29))Then("23-29")

ElseIf([ number]>=30)Then("30")

Thank you,

Vinay

SAP BusinessObjects - Web Intelligence (WebI)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Sep 05, 2014 at 01:42 PM

    Hi Vijay

    Try This

    =If [ number]>=0 and [ number]<=7 Then "0-7" ElseIf [ number]>=8 and [ number]<=15 Then "8-15" ElseIf [ number]>=16 and [ number]<=22 Then "16-22" ElseIf [ number] >=23 and [ number]<=29 Then "23-29" ElseIf [ number]>=30 Then "30"

    Please put screenshot if this is also not working.

    ~Anuj

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 05, 2014 at 01:23 PM

    Hi Vijay,

    Could you explain bit more what is your requirement.

    Does the formula you have written not working?

    ~Anuj

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Mohammed Mustafa osman
    Sep 05, 2014 at 01:35 PM

    Hi Vinay,

    This link will help you

    BOBJ Tricks: Workdays Between Two Dates in Webi

    Regards

    Mustafa

    Add comment
    10|10000 characters needed characters exceeded