Version Budget formula

Options
Sally
Sally Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor
in Planning & Modeling

Hi 

The Current Fiscal Year is Jan 2020 to Dec 2020

No of Past Years : 1

No of Future Years: 1

Current Period: changes monthly

 

For a Sys module, what formula (Boolean type) can be used to select the months for Jan 2020 to Dec 2020 (even though Current Period changes)? 

 

Tagged:

Comments

  • Sally
    Sally Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor

    @Misbah 

    Thanks for your quick reply. 

     

    The Time setting is from Jan 2020 to Dec 2020 with No of Past Years: 1 and No of Future Years: 1

    Current period:  Jan 20 but will changes monthly to Feb 20, Mar 20 etc

    and we would like to have Jan 2020 to Dec 2020 selected as SYS module even though Current period changes.

     

    Sally_0-1591016489851.png

     

    Your suggestions 1 and 2 does not address it as suggestion 1 results in Jan 20 selected whereas suggestion 2 results in all months selected.

    How does suggestion 3 work?

  • Sally
    Sally Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor
    @naushad786
    Thanks for explaining.
  • Sally
    Sally Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor
    @naushad786
    Thanks for the solution.

Categories