cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Formula Question

cothmer
Participant
0 Kudos

Can you tell me what may be wrong with my formula, keep getting message that the key word 'then' is missing. Thanks.

if {IP_FLWSHT_MEAS_1.FLO_MEAS_ID} = "3041000008" and

if IsNULL {IP_FLWSHT_MEAS_1.MEAS_VALUE} then "No Data"

else {IP_FLWSHT_MEAS_1.MEAS_VALUE}

Accepted Solutions (1)

Accepted Solutions (1)

DellSC
Active Contributor
0 Kudos

Take out the second "If".

if {IP_FLWSHT_MEAS_1.FLO_MEAS_ID} = "3041000008" and

IsNULL {IP_FLWSHT_MEAS_1.MEAS_VALUE} then "No Data"

else {IP_FLWSHT_MEAS_1.MEAS_VALUE}

-Dell

Answers (0)