AnsweredAssumed Answered

ValueCount(List(...)) Always returning 1

Question asked by pmccudden on Oct 30, 2017
Latest reply on Dec 5, 2017 by pmccudden

Hey Everyone,


I'm not sure where exactly to post questions like this. There doesn't seem to be a script help section or anything similar. Any pointers?


I'm running into an issue where I want to perform a countif function. I know this can be done by:


ValueCount ( FilterValues ( List ( FieldName ) ; "FilterValue" ) )


However, this didn't work for me and during some testing, I found out that no matter what I did, I could only find 1 value in the field of choice. Different values, but it could only find one at a time. For example, I have a field called "tripCode" that has 4 different records of information: A;A;B;C. After some testing, I've discovered that I can only find one record of the tripCode field at a time. This is the exact one line script that I'm using: (on a OnObjectExit script trigger)


Show Custom Dialog [ "Test" ; ValueCount ( List ( tableName::tripCode ) ) ]


This will only return 1. Am I missing something?