cancel
Showing results for 
Search instead for 
Did you mean: 

WEBI Break on a Calculated Date Column

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Srinivasa,

I recommend to post this note in a dedicated [WEBI forum|;.

Falk