Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

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.


Labels in this area