Having an IIF Statement inside JoinColumnContent??
Posted: Sun Apr 14, 2024 6:49 am
Hello, I was wondering if it's possible to have an IIF statement generate more than 1 response and be comma separated?
Currently I have a field called LocationType, and this column is showing multiple values using the JoinColumnContent expression. My question is for my ProjectLimits column, I wanted to create an IIF statement that says IIF a LocationType is X, then a Y sentence will appear - however, I want it to show multiple sentences if there are multiple LocationTypes...
Example in Row 5 of the screenshot:
Location Type = Hwy Segment, Intersection, Point Location, Bridge
ProjectLimits (desired outcome) = This project runs through the highway, This project has an intersection, This project is not near a road, This project is near a pedestrian bridge
The sentences above would be created using the IIF statement expression:
but I'm not sure how I can get the ProjectLimits column to show this IIF statement AND be comma separated (using the JoinColumnContent expression)
Currently I have a field called LocationType, and this column is showing multiple values using the JoinColumnContent expression. My question is for my ProjectLimits column, I wanted to create an IIF statement that says IIF a LocationType is X, then a Y sentence will appear - however, I want it to show multiple sentences if there are multiple LocationTypes...
Example in Row 5 of the screenshot:
Location Type = Hwy Segment, Intersection, Point Location, Bridge
ProjectLimits (desired outcome) = This project runs through the highway, This project has an intersection, This project is not near a road, This project is near a pedestrian bridge
The sentences above would be created using the IIF statement expression:
Code: Select all
{IIF(Projects_CurrentProjectRevision_LocationDetails.LocationType == "Hwy Segment", "This project runs through the highway",
IIF(Projects_CurrentProjectRevision_LocationDetails.LocationType == "Intersection", "This project has an intersection",
IIF(Projects_CurrentProjectRevision_LocationDetails.LocationType == "Point Location", "This project is not near a road",
IIF(Projects_CurrentProjectRevision_LocationDetails.LocationType == "Bridge", "This project is near a pedestrian bridge", "N/A")}