Hello,
I cannot figure out what in my survey is truncating. I have attached the xls and the logger. I have gone through the xls twice and cannot find what is going wrong. I tried to look at the logger but I don't quite understand yet how to read these. Any help would be great. Thanks!!
Katie.
I finally figured out what was happening. There are certain instances where I used != in a calculation and the the outcome was different then expected. I had not noticed it before as they were calculate fields and I did not see the outcome. When I found the first one I changed them all to note types and sure enough they all had the issue.
Original calculation that produces a long output (see screenshot)
if((selected(${EVENT_TYPE},'R_Sample') or selected(${EVENT_TYPE},'R_Resample')) and (selected(${SD_FLOW_OBSERVED_TYPE},'Flowing') or selected(${SD_FLOW_OBSERVED_TYPE},'Tidal')) and selected(${SD_FIELD_SCREEN_IND},'N'),string('NR'),if((selected(${EVENT_TYPE},'R_Sample') or selected(${EVENT_TYPE},'R_Resample')) and (selected(${SD_FLOW_OBSERVED_TYPE},'Flowing') or selected(${SD_FLOW_OBSERVED_TYPE},'Tidal')) and selected(${SD_FIELD_SCREEN_IND},'Y') and selected(${SD_COLOR_TYPE},'Other'),concat(${SD_COLOR_TYPE},',',${SD_COLOR_OTHER}),if((selected(${EVENT_TYPE},'R_Sample') or selected(${EVENT_TYPE},'R_Resample')) and (selected(${SD_FLOW_OBSERVED_TYPE},'Flowing') or selected(${SD_FLOW_OBSERVED_TYPE},'Tidal')) and selected(${SD_FIELD_SCREEN_IND},'Y') and ${SD_COLOR_TYPE}!=Other,${SD_COLOR_TYPE},string(''))))
Modified calculation that gets the desired outcome. I tried to shortcut by using the != exclusion but it cannot be combined with other if then statements it seems.
if((selected(${EVENT_TYPE},'R_Sample') or selected(${EVENT_TYPE},'R_Resample')) and (selected(${SD_FLOW_OBSERVED_TYPE},'Flowing') or selected(${SD_FLOW_OBSERVED_TYPE},'Tidal')) and selected(${SD_FIELD_SCREEN_IND},'N'),string('NR'),if((selected(${EVENT_TYPE},'R_Sample') or selected(${EVENT_TYPE},'R_Resample')) and (selected(${SD_FLOW_OBSERVED_TYPE},'Flowing') or selected(${SD_FLOW_OBSERVED_TYPE},'Tidal')) and selected(${SD_FIELD_SCREEN_IND},'Y') and selected(${SD_COLOR_TYPE},'Other'),concat(${SD_COLOR_TYPE},',',${SD_COLOR_OTHER}),if((selected(${EVENT_TYPE},'R_Sample') or selected(${EVENT_TYPE},'R_Resample')) and (selected(${SD_FLOW_OBSERVED_TYPE},'Flowing') or selected(${SD_FLOW_OBSERVED_TYPE},'Tidal')) and selected(${SD_FIELD_SCREEN_IND},'Y') and (selected(${SD_COLOR_TYPE},'None') or selected(${SD_COLOR_TYPE},'Yellow') or selected(${SD_COLOR_TYPE},'Brown') or selected(${SD_COLOR_TYPE},'White') or selected(${SD_COLOR_TYPE},'Gray')),${SD_COLOR_TYPE},string(''))))