Level 1 - Model Builder

Star

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

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?

Comments

filip.sypniewski

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.

let me know if it helps?

Star

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

filip.sypniewski

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

Star

@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?

ddb

I am stuck at different situation.

i am getting only two cols.

Karthik31

Hi,

Budget should be neither actuals nor forecast right according to the given business situation

so basically we have to write formula to Budget Line item using NOT FUNCTION

try using NOT function

NOTE: Budget2 line item is not really necessary for this module

Quick Links

Recent release news

October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…
Recording now available! October 29 platform release event
If you missed our October 29, 2025 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…