calculate table fields
Posted on 2007-04-02
My Table1 has these values:
PERCENT (String) //Displays Percentage number
HOURS (String) // I manually enter number of hours)
To do some calculus in the grid i added 2 more calculated fields:
CALC1 (Currency,To get this value i use on calculate fields of the Table1):
Table1CALC1.Value := Query2SALLARY.Value / Table2HOURS_MONTH.Value;
It workz ok...
CALC2 (Currency ...)
How can I get CALC2 to give me results of this formula (if PERCENT ='50' ! !!!):
CALC2 = a * (b * 50/100) ;
Value 'a' is CALC1
Value 'b' is HOURS
Should I make PERCENT and HOURS into integere type fields as they are allways numbers?