on 07-31-2008 9:23 PM
I am working on a WEBI report where i want to break on a column which is a calculated one. The calculation is very simple. I have a Date column in the report. The second column is Previous ( Date Column). So i have 2 date columns in my report. I am using a function called DaysBetween to find a difference between the two date columns. The report format looks like this
Col1 Col2 DateDiff
02-01-2008 02-01-2008 0
02-01-2008 02-01-2008 0
02-01-2008 02-01-2008 0
02-01-2008 01-26-2008 5
02-01-2008 01-31-2008 1
When i break on DateDiff column i would expect the above data to be grouped by 3 different cat. ( 0, 5,1 ). But what i get is 5 different groups. is there a reason why. Any adice on this issue with be greatly appriciated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.