Hi there,
I'm Stuck here. I want to use the ''occurrence'' Column as filter But in the "occurrence" column for each and every column it showing ''Neutral disturbance- occurrence" and "Earth loading -Occurrence" which was shown in Below screenshot ''capture1'' and i want it to modify it as 'Neutral disturbance" or ''Earth Loading" which is shown in ''capture2''. can any one help me what is the calculation i need to write. For reference i'm attaching the worksheet as well.
In the below attached work book i want to use occurrence column as filter by eliminating 'Occurrence' in it.
Thanks In advance.
Create a calculated field as:
IF CONTAINS([Occurance],'- Occurence') // Check if Occurance has ' - Occurence'
THEN TRIM(SPLIT([Occurance],'- Occurence',1)) //TRIM is just precautionary. You can chose not to use it.
ELSEIF CONTAINS([Occurance],' Occurence') // Check if Occurance has ' Occurence'
THEN TRIM(SPLIT([Occurance],' Occurence',1))
ELSE [Occurance]
END
