Skip to Content
avatar image
Former Member

Count of Bol Number between specific days

Hi,

I am trying to make a syntax in Webi 4.0

count (Bol Number) when [v_DaysShipped] between '13' and '20'

and then the next cell on the right should be like

count (Bol Number) when [v_DaysShipped] between '21' and '30

and so on

Region 13-30 Days 21-30 Days >30 Days Grand Total % OF tTotal California Count of Bol Number Count of Bol Number Count of Bol Number

'

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 06, 2015 at 05:07 PM

    or something like this

    This not working !!

    =[count of Bol Nr ] Where ([v_DaysShipped] between 13 and 20 )

    This is working !!

    =[count of Bol Nr ] Where ([v_DaysShipped] = 20 )

    Need to know how and whats the issue with between

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 06, 2015 at 05:23 PM

    Never Mind i got it

    =[count of Bol Nr ] Where ([v_DaysShipped] Between  (21;30))

    Add comment
    10|10000 characters needed characters exceeded