One of my colleagues was trying to use a substitution variable in a web-form and he got the following error message:
“A substitution variable required for this calculation is undefined. Variable: Years_Act
He defined new substitution variable in planning and assigned the value as “FY10:FY13”.
There is nothing wrong here as this can easily be used in calculation script or business rules but when using this in Web-form, we can only have single valid value not range as shown above.
So, few points to note when using substitution variable in web-form are as follows:
1. Make sure you define substitution variable.
2. Make sure value is not blank
3. Make sure you have assigned a valid member name (value) (not range)
“A substitution variable required for this calculation is undefined. Variable: Years_Act
He defined new substitution variable in planning and assigned the value as “FY10:FY13”.
There is nothing wrong here as this can easily be used in calculation script or business rules but when using this in Web-form, we can only have single valid value not range as shown above.
So, few points to note when using substitution variable in web-form are as follows:
1. Make sure you define substitution variable.
2. Make sure value is not blank
3. Make sure you have assigned a valid member name (value) (not range)
No comments:
Post a Comment