field missing

debbie5154

. I have two modules with the same dimensions.

I’m bring fields into the calculation module from the import module.

This works fine for tons but not for percentage distribution.

module detail.png

module detail2.png module detail3.png

I created a test field and change time scale to year and the values show up (summed for the year 100% or 1):

Here is the import module the data is coming from:

import module.png

I can’t find a reason for this to happen and like I said I tried to chat with support but my chat kept getting canceled.

This works fine for tons but not for percentage distribution.

module detail2.png module detail3.png

I created a test field and change time scale to year and the values show up (summed for the year 100% or 1):

Here is the import module the data is coming from:

import module.png

I can’t find a reason for this to happen and like I said I tried to chat with support but my chat kept getting canceled.

Accepted answers

DavidSmith

@debbie5154

I suspect the reason for the zero is that switchover is set to Week 39 (from one of your screen shots) and the line item for Percent Distribution had switchover turned on. I don't know if switchover was turned on for tonnes as well. If it was, it means the data in the source must be the same for actual and plan version

If the data in the source is zero for percent distribution in the actual version for week 35, it will automatically show up as zero in the target as the data is "Actual"

When the source module contains version and the target module doesn't the "current" version value is used whihc is why the data came through

One final thought - Do you actuall y need versions in the target module? - If the data "works" without version, it may be that you can removed versions from the calculation, thus saving 2x the space and calculations

I hope that is useful

David

All comments

harish_bk

Hi Debbie

This is really strange.

When you go to the cell week 35 and percentage distribution in Grape Program by Week module and do a drill down could you see what is the result or press f8 by selecting the cell.

debbie5154

Yes weird....

drill down.PNG

harish_bk

Hi Debbie

If you observe carefully the drilldown is pointing towards Actual version than pointing to plan version.

Even am not sure but could you please see your switchover in Versions just to see if that is an issue.

debbie5154

Weird....here is the drill down for the other field from the same module:

drill down2.PNG

debbie5154

and here is the version info

Why would one come as actual and one as plan....they are coming from the same import

and how to fix it???

harish_bk

Until we have hands on on the system I dont see if I can make a solution.

The easiest work around would be in Grape Program by Week:
1) Delete "Percentag Distribution" Line item
2) Rename the Test Line Item to "Percentage Distribution"
3) Change the time for the line item to weeks from year

Hope this works.

debbie5154

Thanks again for all your help. Your suggestion did not work but got me to an answer....by changing in blueprint to version not applicable, I get the result i need see pixs below:

DavidSmith

@debbie5154

If the data in the source is zero for percent distribution in the actual version for week 35, it will automatically show up as zero in the target as the data is "Actual"

When the source module contains version and the target module doesn't the "current" version value is used whihc is why the data came through

I hope that is useful

David

debbie5154

I do believe that you've uncovered the reason Mr. Smith. Thanks so much for your response.

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Importing from Data Hub: Incorrect or Missing Mappings in Target Model
When importing data from a Data Hub to another model, I'm seeing values in the target model that don't exist in the source. For example, seller assignments are being tagged with subregions that aren't present in the source data - some assignments are missing expected tags, while others are mapped to seemingly random…
ANAPLAN XL View
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.