This is the original list.
This is my new List.
@Sravan_Kumar
I don't see any structural problems with the formula but I have a few suggestions.
1. Break up your formula into the component parts (this is suggested in the PLANS methodology). This will help you determine where the error is.
2. Don't use list properties. Create a system module. This is a much better way to work with the properties of the list. More efficient, and easier to work with formulas. DISCO!
You are missing single quote signs ' in your formula, it should be VALUE(NAME(ITEM('02Hours'))) - 1
However, as @JaredDolich already indicated, try to follow best practice and create System Module to perform any calculations and store attributes instead of creating properties. As one of the reasons, it would be also easier for you to write the formula after typing VALUE(NAME(ITEM( you can then just click on the list name. This way, you will always get proper list name and add single quote signs automatically. It will make things easier for you!
Thanks @JaredDolich.
As always you are the Messiah.
Exactly.
It was my mistake.
Thanks for explaining.
Hi! I would like to propose the creation of a new Administrator role within Anaplan. Currently, the only way to manage users within a model (outside of the Administration tab) is by assigning the Workspace Administrator (WA) role. However, the WA role requires a Model Builder license, which is significantly more expensive…
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
