I have created a calculated measure using Exponential and Datediff function, and the formula is shown below.
[Measures].[CD Dec Interest Rate]) -1) *
In the above formula what i am trying to achieve is finding the difference between previous date and current no of days in days and dividing it by 365 and doing some multiplication after that, When i deployed above formula all my row values
are getting displayed correctly but all my grand totals are displaying as "#VALUE" and when i checked the error, it displays as TYPE MisMatch.
Could some one help me in finding the problem in above formula.
Thanks in advance.
View Complete Post