Skip to Content

Expenditure for fiscal Period minus 1

I need to display expenditure values ( [Expenditure] filtered by fiscal period-1 Fiscal Period is a mandatory prompt and is displayed in Month and year format ex- Apr 2018 . Now the requirement is expenditure should show till mar 2018 only and apr month expenditure should be excluded. Also i need to display calendar days filtered on the selected calendar month where calendar days has all the dates of all the months starting from 2001 till date. Ex-: if fiscal period(mandatory prompt) is selected as Apr 2018 then calendar days should only shows dates of apr 2018 and not of all the month of all the years.

Add a comment
10|10000 characters needed characters exceeded

  • fiscal period is a mandatory prompt and user selects a period to run the report. suppose say user selects dec 2018 then expenditure will show values of all thee months from Jan 2018 till Dec 2018(Data is there from 2018 so it includes all the values). Not the requirement is to restrict the expenditure data to display data till Nov 2018 i.e user selected fiscal period -1 and exclude the dec 2018 expenditure data. For example in the attachment i selected fiscal period as dec 2018 and expenditure shows all the month data and total comes to 458,110.09 but as per the requirement it should exclude the value of dec 2018 i.e 34,383.41 and the total should show as 423,726.689(458,110.09-34,383.4)expenditure.jpg

    expenditure.jpg (78.2 kB)
  • Hi Can you explain with the help of screen shot

Related questions

2 Answers

  • Posted on Oct 24, 2019 at 01:36 PM

    Hi Bubu,

    instead of creating a complex webi just provide a fiscal start and end date prompt in the webi.

    or if you have a fiscal prompt come from BW then try to get one flag from the BW team so u can restrict the database on that flag.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 25, 2019 at 02:24 PM

    Hi Bubu,

    What you can do is pulls 1 year of data in the query (apply the prompt on year also)

    and in the webi get a max fiscalperiod in the variable

    apply the filter on table where

    fiscalperiod <>max fiscalperiod.

    Note query should contain one year of data only.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.