How to create Webi Formula?

[chandrasekhar6]

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...

Thanks,

Chandra.K

[former_member198519]

Check this thread as well

[mhmohammed]

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:

Thanks,
Mahboob Mohammed