Understand why a formula in the List Property is not working?

svbhagat
svbhagat
in Modeling

Hello, I have a list property that has a formula in it that was working and pulling data correctly.  But today, it is not pulling data and I am not able to identify the root cause.

Here is the screen shot of the list property formula:

clipboard_image_0.png

Here is the module where the formula is pulling the data from:

clipboard_image_1.png

Your help in guiding me in the right direction is appreciated.Thanks.

Tagged:

Best Answer

  • VIGNESH.M
    VIGNESH.M
    Answer ✓

    Hi,

     

    It's not like, the data won't be pulled if version dimensions is used in module.

     

    We have 2 option to get the data,

     

    #1. Use select function to get the data.

          Employee Info Properties.Role[SELECT: VERSIONS.Actual] or

     

    #2. Set Current Version

          The data will come based on the current version we set in the versions setting.

     

    I have set current version of the model is "Actual Version"

    001.png

    In Module, I have used versions and Employee Dimension and line item as 'Role'. 

    2.png

    As mentioned above the current version(Actual) data being pulled from the module.

    3.png

    4.png

     

     

    Regards,

    Vignesh M

     

Answers

  • rob_marshall
    rob_marshall

    @svbhagat ,

     

    What is Hourly Employees by Roles Assumption dimensionalized by?  It can only have one list (dimension) in the Applies To and no Time Scale or Version.

     

    Rob

  • svbhagat
    svbhagat

    Hello Rob,

    Thanks for the response back.  The Hourly Employees by Roles Assumptions Module is only dimensionalized by the List - Employees By Role.  The Time Scale is Not Applicable and Versions is All.  Here is a screen shot. These settings have not been changed.  Therefore, I'm puzzled as even with these settings the module was pulling the property from the list correctly before.   

    clipboard_image_0.png

  • kavinkumar
    kavinkumar

    HI @svbhagat,

    Version is also one of the dimensions in your module hence your formula in property is not working. Anaplan is not able to recognize which version should it take hence it is blank. If you want to take particular version then include Select function [ex,Select:Version.Actual ] in your existing formula.

    I hope this helps.

    Kavin.

  • DavidSmith
    DavidSmith

    @svbhagat 

    Also, if you are referencing a module with Versions to a module without, the default will pull from the Current Version.  That is probably why you are not seeing anything (if you haven't got that set)

    You can use this instead of SELECT, if you need it to change dynamically as you change the Current Version setting in the Versions tab

     

    David

  • svbhagat
    svbhagat

    I just want to make sure I understand.  Going back to my original question. 

    I have a formula in my List Property to pull a line item from this module.  Is the List property setup correctly? 

    Are we saying that as long as the module has all versions pulling, the line item from the module will not get pulled into my List property?  


    Thanks

  • svbhagat
    svbhagat

    Thank you.  This clarification helped me resolve the issue.  I changed the current version setting and that has updated the information.  I will also look into using the SELECT formula for future.  

Categories