Guys, I am trying to create a Variable with this parameter but I get syntax error. Please advice!
= If =“0” And Not (Trim() InList (“HENQ” , “HENV” , “HEPQ” , “HEPV”) Or Trim() InList (“NIV” , "NIV " , “SP2S” , “SPST”) Or IsNull()) Or If <>“0” And Trim() InList (“12 MO” , “12 MONTH” , “24 MONTH” , “ALT” , “ALTERNATE” , “ALT TYPE” , “AT” , “F” , " F" , “FULL” , " FULL" , “L” , “LITE” , “REDUCED”) Then “FULL DOC” Else “NO”
kyanforum (BOB member since 2009-05-22)
Hi,
You have 2 “Ifs” but only 1 “Then”. Try removing the second “If” if that helps.
Marek Chladny 
(BOB member since 2003-11-27)
Hi I have 2 variables that define “Full Doc” and I need to make them into 1 variable. Can some one show me how to do it?
Var 1:
= If =“0” And Not (Trim() InList (“HENQ” , “HENV” , “HEPQ” , “HEPV”) Or Trim() InList (“NIV” , "NIV " , “SP2S” , “SPST”) Or IsNull()) then “FULL DOC”
Var 2:
= If <>“0” And Trim() InList (“12 MO” , “12 MONTH” , “24 MONTH” , “ALT” , “ALTERNATE” , “ALT TYPE” , “AT” , “F” , " F" , “FULL” , " FULL" , “L” , “LITE” , “REDUCED”)Then “FULL DOC”
Thanks!
kyanforum (BOB member since 2009-05-22)
Hi,
Try this formula:
= If (<ACT Bulk Purchase Flag>="0" And Not (Trim(<App Approved Product Code>) InList ("HENQ" , "HENV" , "HEPQ" , "HEPV") Or Trim(<App Special Program Code>) InList ("NIV" , "NIV " , "SP2S" , "SPST") Or IsNull(<App Approved Product Code>))) OR (<ACT Bulk Purchase Flag><>"0" And Trim(<BLK Full-Lite-Niv-Stat>) InList ("12 MO" , "12 MONTH" , "24 MONTH" , "ALT" , "ALTERNATE" , "ALT TYPE" , "AT" , "F" , " F" , "FULL" , " FULL" , "L" , "LITE" , "REDUCED")) then "FULL DOC"Marek Chladny (BOB member since 2003-11-27)
thanks…I will give it a try!
kyanforum (BOB member since 2009-05-22)