Solving "Null"

Question

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 · Accepted Answer

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

AGilbert · Accepted Answer

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