i have a requirement for displaying the data for Current_Date-1 and when i try to create a filter using _add_days(current_date,-1) it is not working. Can somebody help me with it....
Hi there,
You have to specify the field that you want the previous days data for as well.
here is a filter I have for a previous days report where [Prev Bus Day] is the field I want the previous days date calculated on
Hope this helps
[Presentation Layer].[Dials & TalkTime].[Date] = _add_days(current_date, [Prev Bus Day])
sorry - and my previous bus day calculation is like this
If([current_day_of_week]=1)
then (-3)
else (-1)
so basically if the current day is monday go back 3 days to get fridays data else just got back 1 day to get the previous business day