cancel
Showing results for 
Search instead for 
Did you mean: 

Count of Bol Number between specific days

Former Member
0 Kudos

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

Region13-30 Days21-30 Days >30 Days Grand Total% OF tTotal
California Count of Bol Number Count of Bol Number Count of Bol Number

'

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Never Mind i got it

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

Former Member
0 Kudos

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