[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