[FX.php List] summation field not being red

[Robert Janssen]

hi people
 
william, to answer the questions you asked .....
 

So, in Filemaker the fields are populated with the correct sum - is  this summation an un-stored calculation field ? correct; un-stored calculation fieldHow is the relationship built ? multiple relations to one database, based on several different global fields 
Result = sum(relation1:uren) + sum(relation2:uren) + sum(relation3:uren) + sum(relation4:uren)
 
Relation1 based on employeenumber, current year and global variable “_relation1” with  fixed value
Relation2 based on employeenumber, current year and global variable “_relation2” with  fixed value
Relation3 based on employeenumber, current year and global variable “_relation3” with  fixed value
Relation4 based on employeenumber, current year and global variable “_relation4” with  fixed value
Are there any global fields being to initialize the relationship ? yes; they make the difference between the different relationsIs there any other related data being exposed ? - Can you see the  field FLEX::uren for example ? In Filemaker the results of the calculated fields are shown correctly. Also of each relation a portal is shown to be able to visually check the resultsSorry for the questions,
 
grtz.
Robert.
 



> From: william.downs at gmail.com> Subject: Re: [FX.php List] summation field not being red> Date: Tue, 15 Apr 2008 14:54:59 +0100> To: fx.php_list at mail.iviking.org> > Hi guys,> > But it's not using Summary fields at all - only the sum function> > So, in Filemaker the fields are populated with the correct sum - is > this summation an un-stored calculation field ?> > How is the relationship built ?> Are there any global fields being to initialize the relationship ?> Is there any other related data being exposed ? - Can you see the > field FLEX::uren for example ?> > Sorry for the questions,> > William> > On 15 Apr 2008, at 13:22, Gjermund Gusland Thorsen wrote:> > Only the reports show the summery fields AFAIK, as it is heavily> > relaying on the current selection.> >> > ggt> >> > 2008/4/15, Robert Janssen <janssen_robert at hotmail.com>:> >>> >> Hello,> >>> >> If anybody could shed some light on my following problem, I'd be > >> much> >> obliged ...> >>> >> The value of a calculated field (summation of a related field ) > >> is not> >> shown / not read by the fx module. (I can see the value of het > >> calculation> >> in filemaker itself).> >>> >> If I change the fieldtype to a number instead of a calculated > >> field, the fx> >> module reads the field perfectly.> >>> >> Here is the summation:> >>> >> Sum(FLEX::uren) + Sum(P125::uren) + Sum(P150::uren) + Sum > >> (P200::uren)> >>> >> greetz.> >> Robert Janssen> _______________________________________________> FX.php_List mailing list> FX.php_List at mail.iviking.org> http://www.iviking.org/mailman/listinfo/fx.php_list
_________________________________________________________________
Probeer Live Search: de zoekmachine van de makers van MSN!
http://www.live.com/?searchOnly=true
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20080416/8fcd0ff4/attachment.html