Filter
Top Products
DIS Digital Conference System User Manual
62
User Manual SW 6005 CAA ver 6.2 RevA.docx
4.8.3.6.2 Syntaxes
The following syntaxes are valid:
+
Add
-
Minus
/
Divide
*
Multiply
and
Two statements combined with ‘and’ shall fulfil condition
or
One of two statements combined with ‘or’ shall fulfil condition
sum(voting_group')
Sum of the given votes for a Voting Group
sum('voting_group',condition)
Sum of the given votes for the Group ‘ABC’ fulfilling the ‘condition’
iif (condition,truepart,falsepart)
If the ‘condition’ is true then the ‘truepart’ is shown, if not the
‘falsepart’ is shown
convert(number,'System.Int32')
Converts a decimal number to the lower integer part.
Example 1:
convert(3,'System.Int32') = 3
convert(2.5,'System.Int32') = 2
Example 2 (25% of Total present is always rounded up to the nearest
integer):
iif(convert(TotalPresent/4,'System.Int32')<TotalPresent/4,
convert(TotalPresent/4,'System.Int32')+1,
convert(TotalPresent/4,'System.Int32'))
4.8.3.6.3 Use of Voting Group parameter
Use of delegate ‘Voting Group’ parameter is a way of counting votes from group of delegates separately
and use this count in calculating Quorum or Passed/Not passed results.
In the following the ‘Voting Group’ parameter ABC has been used for some delegates and DEF for others.
Example 15
To get all delegates with ‘Voting Group’ = 'ABC'
who has cast a vote.
Enclose the ‘Voting Group’
in quotes and use
the SUM-function (you are in fact creating a
sum of the individual results...)
SUM('ABC')
Example 16
To get all delegates with ‘Voting Group’ = 'ABC'
who has pressed button 1 use the expression
SUM('ABC', VOTE1)
Example 17
So if the statement that "passed" is true if yes-
votes for ABC-delegates are greater than no-
votes for DEF-delegates.
SUM('ABC',VOTE1) > SUM('DEF',VOTE3)
Special buttons 4.8.3.7
[Edit]
The button [Edit] is showing a window for creating the SQL statement.
The user can cut and paste from the textbox displaying it. An advanced user may
want to copy the statement to the Microsoft Enterprise Manager’s SQL analyzer to try
out different syntax possibilities or to debug the formulas.