Showing results for 
Search instead for 
Did you mean: 

How to create Webi Formula?

0 Kudos

Hi All,

How to create below scenario formula,

How should show previous month, and total current calendar year.

Example: If I run it for Jan 2017, it should show December 2016 and January 2017. If I run it for April 2017, it would show January 2017 – April    2017. If I ran it for December 2017, it would show Jan 2017 – Dec. 2017. It should always include the previous month and up to the “To Date” that was selected.

Please share your valuable thoughts...



Accepted Solutions (0)

Answers (2)

Answers (2)

Active Contributor
0 Kudos

Check this thread as well

Active Contributor
0 Kudos

Hi Chandra,

How many Months worth of data are you bringing in the report and how are you doing it? Do you want to update the query to bring the data dynamically for certain periods? If yes, try this:

And for the formula in Webi, try this:

Mahboob Mohammed