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 "Measure not applicable" error while using newly created measure in the KPI?
There are various reasons for the newly created measure not to be applicable while publishing a KPI. Possible reasons are as follows: Measure is not created/defined properly. The character type is incorrect. If an expression measure is not applicable ...