Level 1 - Model Builder

Highlighted
Regular Contributor

Level 1 - Model Builder

Hi

In defining SYS09 for Version details, Budget? = NOT(Actual? OR Forecast?)

 

Star_1-1588280639092.png

 

If there is an additional version called Budget2 as below, and Budget? is to be tick-marked under Budget (orange box), 

the formulas NOT(Actual? OR Forecast? OR Budget2?) does not seem work.  Is there any other function that can be applied?  

 

Star_2-1588280950155.png

 

 

 

 

 

4 REPLIES 4
Highlighted
Super Contributor

Re: Level 1 - Model Builder

Hi @Star,

 

why not using just 3 lines

-Actual

-Budget

-Forecast

 

your Budget2 version is still budget version. Then you can easily filter to see all your budget versions.

 

versions.jpg

 

let me know if it helps?

Highlighted
Regular Contributor

Re: Level 1 - Model Builder

@filip.sypniewski
Because there are two versions of Budgets i.e. Budget 1 and Budget 2 or even more.

Highlighted
Super Contributor

Re: Level 1 - Model Builder

@Star 

 

Understood, that is of course normal situation, to include few budget rounds. However, this is still budget version, right? If you check the screenshot from my previous message, you can see that you can have multiple budget versions and they will be still true for Budget? line item for filtering.

Highlighted
Regular Contributor

Re: Level 1 - Model Builder

@filip.sypniewski
Thanks for your reply.  
I had a look at your screenshot again and got what you meant.
Perhaps I did not specify in more detail of what I was trying to get at. What I am looking at is whereby there are more than 3 Versions lines....e.g. Actual, Budget, ForecastQ1, ForecastQ2
In the workshop, the example given was 3 Versions, hence, Budget? = NOT(Actual? OR Forecast?) was used.
In a situation whereby there are more than 3 Versions, how can NOT be used or is there any other substitute function that can be used?