[FX.php List] summation field not being red

Gjermund Gusland Thorsen ggt667 at gmail.com
Tue Apr 15 09:39:47 MDT 2008


That was a FileMaker 7 problem? no?

2008/4/15, Andrew Denman <adenman at tmea.org>:
> On possible solution: If the related tables are in different files and you
>  are on FileMaker Server 7 (and possibly 8 and 9, but I'm not sure since I
>  fixed my databases before moving to 8), the related files must be related
>  like this: 'file:RelatedFile'.  When using the 'fmnet:/' way, calculations
>  on related files would work in FileMaker but not through CWP.
>
>
>  Andrew Denman
>
>
>  -----Original Message-----
>  From: fx.php_list-bounces at mail.iviking.org
>  [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of william.downs
>  Sent: Tuesday, April 15, 2008 8:55 AM
>  To: FX.php Discussion List
>  Subject: Re: [FX.php List] summation field not being red
>
>  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
>
>  _______________________________________________
>  FX.php_List mailing list
>  FX.php_List at mail.iviking.org
>  http://www.iviking.org/mailman/listinfo/fx.php_list
>


More information about the FX.php_List mailing list