Solving "Null"

[KamenRider]

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

[alexnajm]

You are missing a closing parenthesis after [Weighted+]!

[alexnajm · Accepted solution]

([Maturity  (years)])*([Weighted+])

[AGilbert · Accepted solution]

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+])".