Solved

calculate table fields

Posted on 2007-04-02
4
173 Views
Last Modified: 2010-04-04
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
Comment
Question by:srbenavrbe
4 Comments
 
LVL 21

Expert Comment

by:ziolko
ID: 18838957
why don't you write SQL query that will return values already calculated?

ziolko.
0
 
LVL 17

Accepted Solution

by:
TheRealLoki earned 250 total points
ID: 18839484
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
 
LVL 1

Expert Comment

by:Computer101
ID: 21156534
Forced accept.

Computer101
EE Admin
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now