XOR for versions

The lack of summary for versions made me create this formula:

I am trying to get a functionality to have a boolean checkbox which will be FALSE for all other versions, but the one I have selected for the same time period, else - all TRUE. Time periods have this "All periods" summary which can be used in SELECT.

Do you guys have any idea to achive the same any other way?

If Anaplan could have VERSIONS.All versions my formula could look much cleaner and more flexible:

Selected version OR NOT (Selected version[SELECT:VERSIONS.All Versions OR Selected version[SELECT: TIME.All Periods])

Accepted answers

AntonMineev

In this formulation of the question, it will be easier to create alternative versions (with total element or working SUM formulas), implement the calculation on them, and then transfer the result to the native versions. I checked, LOOKUP mapping worked without problems.

It will be easier than doing complex calculations with the PREVIOUS / NEXT version.

Снимок экрана 2021-07-27 в 16.59.26.png

Снимок экрана 2021-07-27 в 17.00.33.png

All comments

JaredDolich

@KirillKuznetsov

Great callout, one that's been brought up a few times. Anaplan cannot sum across versions because of the way Anaplan stores the data in blocks. But there is a cleaner way than the one you have and is discussed here by @rob_marshall @alexpavel and illustrated by @CommunityMember126793

KirillKuznetsov

Jared,

Thank you for your comment.

I saw this discussion, but unfortunately, this approach won't simplify or make it cleaner.

Following this, I will get many IFs or, at least, ORs in my formula and it will make it much longer.

Here is its look with only four versions as examples:

(Boolean[SELECT:VERSIONS.V1] AND NOT (Boolean[SELECT:VERSIONS.V2] OR Boolean[SELECT:VERSIONS.V3] OR Boolean[SELECT:VERSIONS.V4]))

(Boolean[SELECT:VERSIONS.V2] AND NOT (Boolean[SELECT:VERSIONS.V1] OR Boolean[SELECT:VERSIONS.V3] OR Boolean[SELECT:VERSIONS.V4]))

(Boolean[SELECT:VERSIONS.V3] AND NOT (Boolean[SELECT:VERSIONS.V1] OR Boolean[SELECT:VERSIONS.V2] OR Boolean[SELECT:VERSIONS.V4]))

(Boolean[SELECT:VERSIONS.V4] AND NOT (Boolean[SELECT:VERSIONS.V2] OR Boolean[SELECT:VERSIONS.V3] OR Boolean[SELECT:VERSIONS.V1]))

AntonMineev

Hi @KirillKuznetsov!

I tried to reproduce your problem. Did I understand correctly that one version-year combination is selected at the moment?

Снимок экрана 2021-07-27 в 13.51.09.png

I tried to push away from this by defining the year by which we should put FALSE for other versions. To check the year, I used checking all previous and all next versions. Apparently, I came up with the same effect that you have in the first picture. Can you take a blueprint from the attachment and check it on your case?

P.S. I have not optimized the formulas for best practices, this is a prototype.

DCA_Test_1_115310.xlsx

KirillKuznetsov

Thanks for the solution, but not quite what I want.
I must be able to choose one version per year and one year per version.

AntonMineev

Can you send an example of how an introductory form with parameters should look like (version selection-year)?

KirillKuznetsov

When a year unselected the only versions available and the ones which are not selected in another year periods.

In the end it has to trigger the DCA this way.

Hope it helps

AntonMineev

It will be easier than doing complex calculations with the PREVIOUS / NEXT version.

Снимок экрана 2021-07-27 в 16.59.26.png

Снимок экрана 2021-07-27 в 17.00.33.png

KirillKuznetsov

@AntonMineev Yes, I also thought about this option. Though this one requires permanent manual mapping - it is still better looking one.
Thanks!

AntonMineev

I think it is possible to simplify the process of creating and mapping versions through imports.

Then you do not have to fill in the mapping manually, but you can get by with the button (process).

You will need to import on native versions (as source) and import from it into the directory of custom versions. And separately in the mapping.

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…