Skip to Content
0
Dec 19, 2022 at 05:07 AM

LIke, NOT Like or Blank

82 Views

HI, I wish to report from 2 fields in my database

Q1. Was there a delay to starting Y/N.

Q2. Is a multi value field 1-5 for different delay reasons.(String).

In my report I need

if Delay = Y and Reason is “3” then 1

if Delay = Y and Reason is not “3” then 2

if Delay = N then leave blank

I tried:

if {delaystart} = "Y" and { delayreas} like "*2*" then 1

else

if {ech_0023.delaystart} = "Y" and not({ech_0023.delayreas} like "*2*") then 2

else

Numbervar Target; if {ech_0023.delaystart} = "N" then ""

All my answers are coming up blank even when it should be one or 2