Compare several Rows of the same field ( Date) in webi

[former_member811057]

Hello,

I am trying to compare multiple rows of the same field (date) in webi report. The issue is that the compared dates are not always on the previous/next row so I have to compare date 1 from row 1 with date 2 from row 3 both for the same Address ID.

Is there any way how it can be expressed in a formula?

[ayman_salem]

A possible solution is to count the date and if the count > 1 then it will be duplicated.

ex:

v_count_D1: =Count([Date 1]; All) In([Date 1])

v_count_D2: =Count([Date 2]; All) In([Date 2])

...

I hope that what you are looking for and helps.