Count Drop-Down Control values on Editable List View

  • 12 October 2015
  • 0 replies
  • 36 views

Userlevel 6
Badge +10



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






0 replies

Be the first to reply!

Reply