Value from wrong version is returned

Highlighted
New Contributor

Value from wrong version is returned

Hi,
I have a problem where I get value summed by a wrong version returned.
From a module without any versions, I want to pick up FTE values from budget version in another module which has versions and sum by which role the employee has.
The formula looks like this:

'FTE Module'.'FTE'[SUM: 'FTE Module'.'HR-Role', SELECT: VERSIONS.Budget]


The formula above returns the correct FTE value but sums by the HR-role that was entered in Forecast version (which is set as current version if that could be important information).

Any suggestions why this happens?

Description of attached filescreen dumps:

pic1: Blueprint of the module in which I want to present budget FTE data summed by HR-Role.

pic2: Blueprint of the module from which FTE data is collected.
pic3: Presents the data of my test person, which is the data I want to collect. As you can see he's set to HR-Role "Admin local" in Budget version (and "Consultants local" in Forecast version). FTE value is set to 1 for budget version and 0 for forecast version. (Blueprint of module in pic2)
pic4: Result of how data was collected (module blueprint in pic1). As you can see, the FTE value is correct but person (which is the only person under list item "610 - sweden") gets HR-Role for forecast version instead of budget version.
Clarification: list O5-department roster and list O4-PC in described modules are hierarchical lists.

 

 

 

 

12 REPLIES 12
Highlighted
Super Contributor

Re: Value from wrong version is returned

@LisaTonnerfors 

You need to use a SUM SELECT combo in your SUM formula.

The following Anapedia link will guide you through how to do this;

 

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/SUM-SELECT.html 

Highlighted
Super Contributor

Re: Value from wrong version is returned

Or if this doesnt work create a staging module where you create the mapping used in the sum for just the Budget version.

Use SELECT to pull through the required mapping just for BUDGET
Highlighted
New Contributor

Re: Value from wrong version is returned

Hi Chris!
I thought I was using the SUM SELECT combo?

'FTE Module'.'FTE'[SUM: 'FTE Module'.'HR-Role', SELECT: VERSIONS.Budget]

 

Are you referring to another formula?

 

Thanks!

/Lisa

Highlighted
New Contributor

Re: Value from wrong version is returned

Staging module would be required.

Highlighted
Super Contributor

Re: Value from wrong version is returned

Yes, I believe you are.
As others have suggested stage the calculation where you first select budget version and then from that module lookup...
Highlighted
Certified Master Anaplanner

Re: Value from wrong version is returned

It seems like the SELECT is not doing what is expected of it. Try this:

 

Go to settings --> versions --> set your budget version as "current". ANaplan always retrieves data from current version by default when the target module has no versions.

AlejandroGomez_0-1601372904814.png

 

So it should provide you with the right outcome. Please let us know.

 

EDIT: are you using switchover? if yes, on which period? The formula that you are using works for me when I do not use any switchover.

 

Cheers

 

Alex

 

www.olivehorse.com

 

Highlighted
New Contributor

Re: Value from wrong version is returned

@AlejandroGomez Problem is that Budget column was one example. I want to have a column for forecast and actual as well so I can't depend on which version is set to current version. I thought the SELECT: Versions.xxx would do it byt obviously not.
I'm not using switchover anywhere.

I'll try a staging module but spontaneously it feels like the problem will persist.

 

Highlighted
Certified Master Anaplanner

Re: Value from wrong version is returned

 I see your point about having a Line Item per version.

 

Since I tried to replicate your case and seems to work fine in my case, I would suggest you to re-enter the formula one more time from scratch (now that switchover is disabled) and I would put the SELECT clause in first place, then the SUM, as the example from anapedia shows: https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/SUM-SELECT.html

 

Please, give it a shot and let us know.

 

Highlighted
New Contributor

Re: Value from wrong version is returned

@AlejandroGomez As a test, I created a separate module with only this line item to avoid any other distractions or settings that may affect. So the formula has been rewritten from scratch. I have tried both having SELECT before SUM and the the other way around. Switch over was never enabled.

When you tried this, did your module (the one with the formula) have versions? Because if I enable versions, it works fine for me. Once versions are removed from module, it takes the HR-Role value from version set to current version instead of the version I am using by SELECT.

Strange thing though that it takes correct FTE-value but sums on the wrong HR_Role?