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

Highlighted
Contributor

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

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.

7 REPLIES 7
Highlighted
Master Anaplanner/Community Boss

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

@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

Highlighted
Contributor

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

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

Highlighted
Master Anaplanner/Community Boss

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

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.

Regards,
Kavin.
Highlighted
Master Anaplanner/Community Boss

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

@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

Highlighted
Contributor

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

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

Highlighted
Master Anaplanner/Community Boss

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

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

 

Highlighted
Contributor

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

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.