I'm attempting to write a formula expression in Pentaho Report Designer 3.9. The expression will take the SEMIANNUAL1_VALUE attribute which is an int or number-field and display "N/A" when the value is -1. Below is the expression I currently have that is not working.
I have this expression in the "value field" in Pentaho Report Designer which should handle this exception. Your help is appreciated.Code:=IF([SEMIANNUAL1_VALUE] = -1 ; TEXT("N/A"); [SEMIANNUAL1_VALUE] )