If statements with concatenations

EMMA_UM

I've read many posts on here but am still having a tough time getting this statement working. Any help is GREATLY APPRECIATED! I broke it down to make it a little easier to read.

Thank you!

 

 

if(selected(${WB}, 'RV'), concat(${RV_ST_LP},${FD_RV},${FD_ST},${RV_ST_WF},${RV_ST_Nat_Mod},${RV_ST_Hum_Mod}),

if(selected${WB}, 'ST'), concat(${RV_ST_LP},${FD_RV},${FD_ST},${RV_ST_WF},${RV_ST_Nat_Mod},${RV_ST_Hum_Mod}),

if(selected(${WB}, 'LK'), concat(${LK_PD_LP},${WB},${LK_PD_WF}),

if(selected(${WB},'PD') and ${LK_PD_LP} != 'TE', concat(${LK_PD_LP},${WB},${LK_PD_WF}),

if(selected(${WB}, 'PD') and ${LK_PD_LP} = 'TE', concat(${LK_PD_TE},${WB},${LK_PD_WF}, 'NULL')))))

 

 

Katie_Clark

Sorry, I didn't notice this the first time....I think you need a parentheses here too? Because the 'NULL' is the final ELSE statement. (I highly recommend writing these statements in an editor like this with syntax highlighting! It always helps me with the grouping.)

If this still doesn't work I'll try to help more, but...let's try to get the simple stuff out of the way first 🙂