by Gary » Wed Feb 03, 2010 11:05 am
For the Count, Average functions and all other math functions, SQL or math criteria can be added to Count or average only specific Values called from a table (Look Up table for the criteria or the where statement of the function)
Eg: Sum or count in Add and Edit, View and List
Insert/Select (sum/count/multiply/subtract['NumberVariable']) to/from 'TableVariableName' where 'Numbervariable' = 'Variable1'
**(Insert only)Values (sum/count/multiply/subtracted/average/square/root values values)