HI,
Would like to ask for your help on how I can fix the "NULL" results. Got an error that states, "Parse Error at char(33): Unmatched (Expression #1).
The current data type for Maturity (years) is Doble and for Weighted+ is Fixed Decimal (9.6). Not sure if they are compatible or not which seems the cause of the error.
Please help on how I can resolve this.
Thanks,
Kamen
Solved! Go to Solution.
You are missing a closing parenthesis after [Weighted+]!
([Maturity (years)])*([Weighted+])
You have an unclosed parenthesis around [weighted+] causing the problem. Also, you don't need any of the parenthesis in expression 1. "[Maturity (years)] * [Weighted+]" would evaluate the same as "({Maturity (years)]) * ([Weighted+])".