Showing dates as dates+1 in the reporting- Webi

[Former Member]

Hi guys

For one of the users, we have a monthly report which goes like this:

Date Cost

01/02/2017 $200

02/02/2017 $300

.

28/02/2017 $234

Now these dates reflect what happened in the previous day as the load finishes...

Current scenario: for 30th Mar, the latest report date will be 29th Mar

But she wants to display the report date as 30th mar for 29th data and so on...and this way, she will report 31st mar data at 1st apr...

I created a variable as RelativeDate(Date;1) to give me day +1

But is this the ideal way to achieve this?

[former_member198519]

Yes. If that's what you need? There is no right or wrong if your logic works. The formula is there for this reason

[amitrathi239]

Yes this is the only way to do at webi report level.

if this is required for multiple reports then you can create object at universe level to add 1 more day.