Variance Report Issue

Monpero
Monpero
in Modeling

Hi All,

I am creating a variance report using a custom list mapping to a native list in order to bring the data to the module with fake list.

After I sum it I noticed the Actuals data is not flowing in the actuals for the target module but in one of the version only, And other versions afre not flowing to the target module, I'm wondering is there a bug in Anaplan or something is wrong with the mapping module.

The Module data source contains actual values, below is a screen shot.

image.png

image.png

Here below is the mapping module( Dimensioned by Native version only, which is the left row below) Line item drop down contains the Fake Version List to map.

image.png

The issue is I get the Actuals Data in the Forecast (This module also have the user list in the dimension)

image.png

Below is the source Module data which has data for Actuals.

image.png

What is the likely course of this? Is there a workaround on fixing it?

Answers

  • ravi
    ravi
    edited June 2023

  • AkhilEmmanual
    AkhilEmmanual

    @innocent I think you had checked actual as current version that may be reason why only actual data is flowing. Its better to run an import action rather than connecting it with formula.You can directly import data from NR T06 to NR T07. I think all the dimensions are same in these 2 modules only difference are default version and your version list just map them while importing.

  • Monpero
    Monpero

    Thank you @ravi and @AkhilEmmanual for the suggestions.

Categories