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’)