on 01-06-2015 4:58 PM
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 |
'
Never Mind i got it
=[count of Bol Nr ] Where ([v_DaysShipped] Between (21;30))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.