Skip to Content
Former Member
Nov 15, 2016 at 03:18 PM

Yesterday's data in webi report


Dear Experts,

I have created a Dashboard to report on YTD, MTD, QTD and Today's data. When user selects today's date in promot, the above data should display in the dashboard. Dashboard is working fine.

User had a new requirement to display data for yesterday also in the above report when he select today's date. I created variables and wrote the formula below and it works.

=[Total Hours] Where ([Hours Year] = [UserInputYear] And [Hours Month] = [UserInputMonth] And [Hours Today] = [UserInputDay]-1)

But the Issue is on 1st day of the every month. Let's say the user selects 1st of November and he should get yesterday data of 31st october.

As per the above formula [Hours Today] = 1 and [UserInputDay]-1 gets 0. So the day nos doesn't match and even the month nos also doesn't match. so the report doesn't display any data.

Please can some one help me in this. I have checked many blogs and used the Relativedate function too and the formula doesn't work.