Skip to Content

Hi ,

I want to calculate measures between days ex(1-30 days,31-60days, 61-90days like…) in webi report  for user given date.

now i am  using relative position to implementing above requirement but not sure it ll give right data . if you have any other logic please provide solution.

1-30days  Name called  V1


=RelativeDate([vUser Date];-30)

31-60days   V2


=RelativeDate([V1];-60)   


1- 30 days measure calculation

=[Hours Worked] Where ([Pay Period Ending Date]<=[vUser Date] And [Pay Period Ending Date]>[V1])

31- 60 days measure calculation


=[Hours Worked] Where ([Pay Period Ending Date]<=[vUser Date] And [Pay Period Ending Date]>[V2])


Thanks,

S Suryateja.


To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply