Why do I get an error produced due to the declared variable #monthdiff# on changing the expression?
Try the following steps: 1. Change the computed measure to an expression measure. 2. Mention Measure ID instead of Measure Name, in the expression. For example, Current formula --(Gross Sales/((Opening Stock+Closing Stock Value)/#monthdiff#+1)) Expected formula --(Sales Value at PP/((Opening Stock+Closing Stock Value)/#monthdiff#+1)).
Related Articles
Why do I get the error 'Measure not applicable', when I use the created expression measure in KPI?
The reasons could be any of the following: Measure ID is not prefixed with Table Name. Expression is not correct. This error can also occur in newly created measures due to the following reasons: Measure is not created/defined properly. The character ...
How can I resolve the error 'Variable not set '?
One of the many causes for such problem is, if the base measure column is not defined in the aggregate table (for e.g. Gregorian aggregate table ). Define the base measure to solve the issue.
I get an error message 'This report has already been scheduled'. How to solve this?
When you schedule a report, a unique object is created through a single request. The error you received can occur, when the same request is re-initated and when the same object is referred. To avoid the error, refresh the KPI by selecting it from the ...
Why do I get 'Email address is not valid' error while adding a user?
This error is displayed when special characters (!,#,$,%,^,&,*) are used in the email address. Please remove the special characters from the email id to solve the problem.
Why do I get the error message 'Dimension is not available for selected measure'?
If the table name or the column name defined in the data model differs with the way it is defined in the database, then the error occurs. For Example, If the table name in data model is dim_product_stockage and the name given in the table is ...