Skip to main content


 

Symptoms


Count Drop-Down Control values on Editable List View
 

Diagnoses


One of our editable list columns has drop-down list control where we have 2 values: A and B
This column can't have null/empty value and we must have at least one row with value A selected.
So, we want to count the number of each drop-down values, to validate if the count of rows with value A selected is more than zero.
 

Resolution

1- add new column with a data label control and Call it dlRowSum
2- click on the column and go to expressions in the properties to add an expression
3- you expression should be:

SUM(If(Value = A), 1,0)

4- Add another expression and call it ListSum:

List Sum (dlRowSum)

then check in your rule the value of the ListSum expression if it's greater than zero




 
Be the first to reply!

Reply