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?