IF Else statement with Concat

Question & Answer
,
1

I am trying to use if else case statement to concat fields and for some reason my code keeps throwing an error and I cant figure out why

ifelse(

isNotNull({site_selected_actual}), concat(‘A’,{site_selected_actual}),

isNull({site_selected_actual}) AND isNotNull({site_selected_forecast}) AND isNotNull({site_selected_planned}),concat(concat('P ',{site_selected_planned}), ’ | ', concat('F ',{site_selected_forecast}),

isNull({site_selected_actual}) AND isNull({site_selected_forecast}) AND isNotNull({site_selected_planned}), concat(‘P’,{site_selected_planned}),

isNull({site_selected_actual}) AND isNotNull({site_selected_forecast}) AND isNull({site_selected_planned}),concat('F ',{site_selected_forecast}),

isNull({site_selected_actual}) AND isNull({site_selected_forecast}) AND isNull({site_selected_actual}),’ ',‘NA’)

2

Found the error. I was missing a parenthesis.

3

@selam_tekie Glad to hear that you found the issue. Thanks for letting us know!

1 Like