dbTalk Databases Forums  

How to use a computed item in sub-summary

comp.databases.filemaker comp.databases.filemaker


Discuss How to use a computed item in sub-summary in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Vincent Clerc
 
Posts: n/a

Default How to use a computed item in sub-summary - 08-12-2005 , 04:53 AM






I try to create a layout with two sub-summary. The first one is a text field
and the second is a computed field. Both fields are included in the sort
request.
Computed field looks like this:
Si ( Date limite <= Annee ( Obtenir (DateActuelle) ) ; "Immédiatement" ; Si
( Műrissement > Annee ( Obtenir (DateActuelle));"Attendre";"Maintenant" ) )

Result is: The layout summaries according to first item but not to the
second one (the computed one). If I use as second sub-summary a non computed
item (eg. Text) layout summaries according to both items.
It looks like the computed item is not handled in sub-summaries.
Is their any restriction on sub-summary when using computed items?
Thanks for any suggestion. Best regards
--
Vincent CLERC


Reply With Quote
  #2  
Old   
Remi-Noel Menegaux
 
Posts: n/a

Default Re: How to use a computed item in sub-summary - 08-12-2005 , 05:49 AM






As far as I understand what you say :
Make sure that the summaries correspond to a field present in the
'body'.
I would try to put your formula in the record itself, and then make a
summary of it.
PS : we may continue in french if you wish (privately).
Remi-Noel


"Vincent Clerc" <null (AT) null (DOT) com> a écrit dans le message de news:
BF223E41.3EFF%null (AT) null (DOT) com...
Quote:
I try to create a layout with two sub-summary. The first one is a text
field
and the second is a computed field. Both fields are included in the
sort
request.
Computed field looks like this:
Si ( Date limite <= Annee ( Obtenir (DateActuelle) ) ; "Immédiatement"
; Si
( Műrissement > Annee ( Obtenir
(DateActuelle));"Attendre";"Maintenant" ) )

Result is: The layout summaries according to first item but not to the
second one (the computed one). If I use as second sub-summary a non
computed
item (eg. Text) layout summaries according to both items.
It looks like the computed item is not handled in sub-summaries.
Is their any restriction on sub-summary when using computed items?
Thanks for any suggestion. Best regards
--
Vincent CLERC




Reply With Quote
  #3  
Old   
Shadenfroh
 
Posts: n/a

Default Re: How to use a computed item in sub-summary - 08-12-2005 , 01:45 PM



Not sure if I'm on the right track here, but look at the GetSummary
function.

Consider the following:

S_Sales (summary of sales)
S_Costs (summary of costs )

Let's say I need to calculate profits for each company:

C_Profits = GetSummary ( S_Sales ; Company ) - getsummary ( S_Costs ;
Company )

If I just say "S_Sales - S_Company", I'll get the grand total, not the total
per Company.

HTH.

--

Shadenfroh
shadenfroh (AT) yahoo (DOT) com

"Vincent Clerc" <null (AT) null (DOT) com> wrote

Quote:
I try to create a layout with two sub-summary. The first one is a text
field
and the second is a computed field. Both fields are included in the sort
request.
Computed field looks like this:
Si ( Date limite <= Annee ( Obtenir (DateActuelle) ) ; "Immédiatement" ;
Si
( Műrissement > Annee ( Obtenir
(DateActuelle));"Attendre";"Maintenant" ) )

Result is: The layout summaries according to first item but not to the
second one (the computed one). If I use as second sub-summary a non
computed
item (eg. Text) layout summaries according to both items.
It looks like the computed item is not handled in sub-summaries.
Is their any restriction on sub-summary when using computed items?
Thanks for any suggestion. Best regards
--
Vincent CLERC




Reply With Quote
  #4  
Old   
Vincent Clerc
 
Posts: n/a

Default Re : How to use a computed item in sub-summary - 08-13-2005 , 01:27 AM



Merci Remi,
I created an other field containing the result of the computed field and
could successfully summaries according to both fields.
May be it helps somebody else.
--
Vincent CLERC
Le 12.8.2005 12:49, dans 42fc7e96$0$28162$636a15ce (AT) news (DOT) free.fr, «*Remi-Noel
Menegaux*» <rnmenegaux (AT) free (DOT) fr> a écrit*:

Quote:
As far as I understand what you say :
Make sure that the summaries correspond to a field present in the
'body'.
I would try to put your formula in the record itself, and then make a
summary of it.
PS : we may continue in french if you wish (privately).
Remi-Noel


"Vincent Clerc" <null (AT) null (DOT) com> a écrit dans le message de news:
BF223E41.3EFF%null (AT) null (DOT) com...
I try to create a layout with two sub-summary. The first one is a text
field
and the second is a computed field. Both fields are included in the
sort
request.
Computed field looks like this:
Si ( Date limite <= Annee ( Obtenir (DateActuelle) ) ; "Immédiatement"
; Si
( Műrissement > Annee ( Obtenir
(DateActuelle));"Attendre";"Maintenant" ) )

Result is: The layout summaries according to first item but not to the
second one (the computed one). If I use as second sub-summary a non
computed
item (eg. Text) layout summaries according to both items.
It looks like the computed item is not handled in sub-summaries.
Is their any restriction on sub-summary when using computed items?
Thanks for any suggestion. Best regards
--
Vincent CLERC





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.