Crystal Formula Question

This question is answered

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}

Correct Answer

February 04, 2015 at 19:18 PM

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

0 Likes 0 View this answer in context