• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 186
  • Last Modified:

calculate table fields

My Table1 has these values:
ID (Autoinc)
ST_POST (string)
POST_DESC (string)
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?
0
srbenavrbe
Asked:
srbenavrbe
1 Solution
 
ziolkoCommented:
why don't you write SQL query that will return values already calculated?

ziolko.
0
 
TheRealLokiSenior DeveloperCommented:
If you want to keep it as strings, then you could do something like this :-

procedure TForm1.Table1CalcFields(DataSet: TDataSet);
var
  calc1, calc2: double; // storing in temp variables so you can easily work with them
  percent_: double;
  hours_: integer;
begin
  calc1 := Query2SALARY.Value / Table2HOURS_MONTH.Value;
  Table1CALC1.Value := calc1;
// now calculate CALC2
  // if using strings
  percent_ := 0; // default
  hours_ := 0; // default
  if (not Table1PERCENT.IsNull) then
    percent_ := StrToIntDef(Table1PERCENT.AsString, 0); // default to 0 if not set
  if (not Table1HOURS.IsNull) then
    hours_ := StrToIntDef(Table1HOURS.AsString, 0); // default to 0 if not set
  calc2 := calc1 * (hours_ * (percent_/100)) ;
  Table1CALC2.Value := calc2;
end;
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now