Jump to content

MJK.NSW

Members
  • Content Count

    18
  • Joined

  • Last visited

Community Reputation

0 Neutral

About MJK.NSW

  • Rank
    member
  1. forget it, senior's moment ! .... also didn't realize round() works in time
  2. I know it's an old post, but how do you get from the decimal back to the a time format
  3. mmm... the only problem is the "scores::score" in mine (Hours::average) is based summary fields which I can't index and I get a 'missing index' error ... grrrr
  4. mmm... the only problem is the "scores::score" in mine (Hours::average) is based summary fields which I can't index and I get a 'missing index' error ... grrrr
  5. Hi Comment, after digging around I found you've already given advice on doing rankings, as below, so I'll give that a go, thanks Usually this is done by defining a self-join relationship matching the event (and age group, etc.) and comparing the results, e.g. Scores::EventID = Scores 2::EventID AND Scores::AgeGroup = Scores 2::AgeGroup AND Scores::Score < Scores 2::Score The rank is then given by a calculation field = Count ( Scores 2::ScoreID ) + 1
  6. actually, after digging around I found this post from Comment :- Usually this is done by defining a self-join relationship matching the event (and age group, etc.) and comparing the results, e.g. Scores::EventID = Scores 2::EventID AND Scores::AgeGroup = Scores 2::AgeGroup AND Scores::Score < Scores 2::Score The rank is then given by a calculation field = Count ( Scores 2::ScoreID ) + 1
  7. Hi, the file is about 240megs, but it's really just the cacl I'm after. in excel there's a rank() function which returns a ranking 1,2,3,4, etc for a chosen list of numbers basically I was hoping someone would know the maths behind that excel function
  8. goto Video table Layout perform find goto first record loop set variable $JobID set variable $EmployeeID set variiable $video goto layout Hours new record set field JobID, $JobID set field EmployeeId, $EmployeeID set field Video length, $video next record, exit after last endloop then do the same for the Employee table, collecting the EmployeeID, JobID and Hours data for each record in the found set In Hours table I can then sort either by JobID or EmployeeID (depending on how I want it to look) and have the summaries calculating properly, one totaling the
  9. Hi, I've got a clalc field as follows Empl 1::average= .07865 Empl 2::average= .8723 Empl 3::average= .5432 Empl 4::average = 1.22234 and I want to put another field "ranking" so that Empl 1::ranking=4 Empl 2::ranking=2 Empl 3::ranking=3 Empl 4::ranking=1 it's in an already sorted layout that can't be re-sorted (otherwise I'll loose the summary calcs) and it doesn't need to be displayed in order (1,2,3 etc) just show the ranking calc field, so I'm hoping some mathimatical genius might come up with a calculation ? cheers
  10. also, the Hours is just a temp in order to display the summaries / averages, the script first deletes all the records
  11. OK, what I've done is create a Hours table. Then a script goes to the Employee table, does it's find (as per user input) then goes through a loop setting variables for JobID, EmployeeID and hours and then to the Hours layout and adds new records, setting the 3 fields for each. When finished it then goes to the Video table, does the same find criteria and repeats the adding new records to the Hours table with the JobID, EmployeeID and hours. I go to the layout based on Hours, sorted by JobID and do the various summaries, though I found to get averages I could not use the Summary fields,
  12. how do I create each new record in Hours table for each relevant record in the Employee and Video tables ? if I use calc fields for the employee::hours and the video::minutes data then I'm in the same position... I have to use summary fields in Employee and Video tables to collect ALL the relevant records. I can't use script triggers to add a new record as the user doesn't need to update the 1 specific field (there's 3 fields for video time (Hrs, Mins & Secs !))
  13. unlimited can work on the same job, but in reality usually no more than about 5 sorry, "goes" mean that an employee might do some work on the job then sign off. Then some time later do some more work and sign off. If this happens there are 2 records for that employee in the Employee table for that job (JobID) a separate Hours table !! ... I think that might be the go ... using calc fields not lookup ??
  14. yep, ok, sorry 3 tables - Job, Employee::Hours & Video::Minutes for each job an employee might take some video Jobs and Employees relate via a JobID field. Employees and Video relate via EmployeeID and JobID mostly there will be one Employee record per Job, but multiple Video records per employee per job (video taken on different days by the same employee for the same job) However, sometimes an employee might have a few goes at the same job so there might be multiple records in Employee table where the JobID is the same I wanting to total the Video::Minutes
  15. Hi, I only program occasionally and feel as though I've overcome this before... but can't recall how I've 2 tables A and B, both can have more than 1 related record with the other, when I do a summary in A where B has more than 1 related record, I get the multiple A values (and therefore they all sum() ) they but I only want that value once, and visa-versa. I know I can create 2 layouts but Ideally I'll like to be able to do it on 1 hope if explained it properly thanks
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.