Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Webi Access to previous record of dataprovider to

hello all, i am trying to access a particular row in a data provider in my webi.

here is my table

so as the days progress, i want the previous records data. so, if the day today is 5/7/12, how can i  return the Revenue Measure for the previous record, i.e. 37,342.35

thanks in advance

Former Member
Former Member replied

Hi

=Previous([Revenue]) Where ([Calendar Day]=RelativeDate(CurrentDate();-1)) to get the Revenue value for the previous day

=Previous(([Revenue]) Where ([Calendar Day]=CurrentDate()) to get the value of the previous record of the current date

Regards

RR

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question