AnsweredAssumed Answered

Evaluating the result of a FilterValue

Question asked by ColinJim on Jun 11, 2013
Latest reply on Jun 12, 2013 by ColinJim

Title

Evaluating the result of a FilterValue

Post

     Hi all:

     I have a calculated field, c_photo_file_name that I want to evaluate based on the contents of a field (photo_tag) with multiple values.  

     My evaluation is:

     1) if the photo_tag field contains the word "Approach" I want c_photo_file to be Direction & "Approach";

     2) alternatively if the photo_tag field contains the word "Elevation" I want c_photo_file to be Direction & "Elevation";

     3) and if photo_tag does not contain either of those two words I want it to return Photo_ID. (Direction is another field defined within the table)

     I have been trying to use (but failing):

     Case (FilterValues( Photo_Tag; "Elevation")="Elevation; Direction & "Elevation"; FilterValues( Photo_Tag; "Approach")="Approach; Direction & "Approach"; photo_ID).

     Testing the FilterValues( Photo_Tag; "Elevation")="Elevation on its own returns "Elevation" for any records that contain that value in the Photo_Tag field but the calculation falls apart when I embed it into the Case().

     Any thoughts?

     Much thanks in advance!

      

Outcomes