Calculator and Math Functions for values in different tables
Posted: Wed Feb 03, 2010 10:47 am
Need popup calendar and .net math functions for the asp.net maker, only count and averages are supported for a table column.
Need popup calendar and .net math functions for the asp.net maker, only count and averages are supported for a table column.
Specially the sum(two different columns in single or different table), divide (two different columns in single or different table)multiply (two different columns in single or different table), Subtract(two different columns in single or different table), square and roots(values from two different columns in single or different table).
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)
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)