Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal Formula Question

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}

replied

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 View this answer in context
Not what you were looking for? View more on this topic or Ask a question