Conditional Formatting

[Peter Clifton]

Richard,

Summary fields can be used in Browse Mode. They display the  
summarized data of the records
being browsed. In my case it would display the average of the  
students records I'm browsing.
If I'm browsing the student records of Class A, then the "Test  
Average"  will display the average for that class.

I agree, I could simplify conditional formatting by using the Value  
function, that is, format the field if  the Value is greater than .....
However in many respects this would defeat the purpose, as I have  
many classes, and the aim was to have all this conditionally  
formatting happen automatically, dependent upon the records I'm  
browsing. Otherwise I would have to change the conditional formatting  
value each time a new set of records was being browsed.

Peter


On 09/07/2008, at 13:02, Richard DeShong wrote:

> Peter,
> When you say that "Test Average" is a Summary field, then I am not  
> clear
> what you mean.  I use Summary fields to display data in Preview  
> mode on
> reports.  My understanding is that they don't have a value in  
> Browse mode.
> If you have a Student rcd that is related to multiple Test rcds,  
> then I
> think you would want a Calculation field in the Student rcd that  
> uses the
> Average function to calc the avg of all of the related Test::Score  
> values.
>
> Also, as a test, consider simplifying your conditional formatting.  
> How
> about just using a "if Test Average is about a certain number"  
> test?  Maybe
> you are not "seeing" the correct Test Average value.
>
> --
> Richard DeShong, Athletic Study Center, UCBerkeley
>
> -----Original Message-----
> From: Peter Clifton
>
> The "Test Average" is a Summary field (Average of "Test Score").
> "Test Score" is a Calculation Field ......  Int ( Test Raw Score / .
> 25 ) & "%"
>
> "Test  Average" is stored in each student record in the external file.
>
> I tried referencing "Test Raw Score" field as well, thinking that may
> be the problem, but without success.
>
> Regards,
> Peter
>
> On 09/07/2008, at 11:13, Richard DeShong wrote:
>
>> When I create a relationship to a table in another file (an "external
>> table"), and then use conditional formatting, formula, and
>> reference fields
>> in the external table, the conditional formatting works.  So I was
>> wondering
>> if one or both fields you are trying to use are actually stored in
>> your
>> external?  Of suspicion would be your "Test Average" field.  Where
>> is that
>> number coming from?  Is it a stored field in each student record?
>>
>> --
>> Richard DeShong
>> IT Services, City of Piedmont
>> 510-642-5123 Office
>> 925-285-1088 Cell
>>
>> -----Original Message-----
>> From: Peter Clifton
>>
>> I am not using the Self function, the field being conditionally
>> formatted is from another file, through an external file reference.
>> (Works fine in that file)
>>
>> Version 9.0v3 Adv. Mac OS 10.4.11
>>
>> The formula I'm using is......... Related File:Test Score  > Related
>> File: Test Average
>>
>> The relationship between the two files is based on the Students
>> name.  All other related calcs work fine.
>>>
>>> On Jul 4, 2008, at 6:00 PM, Peter Clifton wrote:
>>>
>>>> Is it possible for conditional formatting to work on related files?
>>>>
>>>> In "File A" I have conditonally formatted a field to show if a
>>>> student's score is above average, and it works fine in that file.
>>>> When I attempt to do the same thing in a related file using the
>>>> data from "File A" it fails to work.
>>>>
>>>> Any thoughts?
>>>
>>> What is the formula, Peter?  And which precise version of FM is  
>>> this?
>>>
>>> If the formula uses the Self function, and if the field being
>>> conditionally formatted is indeed from another file (through an
>>> external file reference), then it will not work due to a bug in
>>> FM.  Don't use Self -- instead hard-code the field's name into the
>>> conditional formatting formula, and it should work.
>>>
>>> regards,
>>> Darren
>>>
>>
>>
>> _______________________________________________
>> FMPexperts mailing list
>> [hidden email]
>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Richard DeShong]

Peter,
Two things: First, the simplified conditional was meant to be
just a debugging test - just to see if you were getting the
number(s) you were expecting.  This leads to the 2nd thing.
You're right (I was "mis-remembering"), Summary fields do have
a value in Browse mode.  But it's important to remember that
Summary fields are associated with multiple records, and their
Value can change depending on your found set.  My concern was,
from the perspective of an external file, what is the Found Set
on which on which your summary field is suppose to be based?  
I still suggest that if you mean to maintain a Test Avg for each
student, then this should be a "regular" field (calc or not).

HTH's
--
Richard DeShong, Athletic Study Center, UCBerkeley

-----Original Message-----
From: Peter Clifton

Summary fields can be used in Browse Mode. They display the  
summarized data of the records
being browsed. In my case it would display the average of the  
students records I'm browsing.
If I'm browsing the student records of Class A, then the "Test  
Average"  will display the average for that class.

I agree, I could simplify conditional formatting by using the Value  
function, that is, format the field if  the Value is greater than .....
However in many respects this would defeat the purpose, as I have  
many classes, and the aim was to have all this conditionally  
formatting happen automatically, dependent upon the records I'm  
browsing. Otherwise I would have to change the conditional formatting  
value each time a new set of records was being browsed.

On 09/07/2008, at 13:02, Richard DeShong wrote:

> Peter,
> When you say that "Test Average" is a Summary field, then I am not  
> clear what you mean.  I use Summary fields to display data in
> Preview mode on reports.  My understanding is that they don't have
> a value in Browse mode.
> If you have a Student rcd that is related to multiple Test rcds,  
> then I
> think you would want a Calculation field in the Student rcd that  
> uses the
> Average function to calc the avg of all of the related Test::Score  
> values.
>
> Also, as a test, consider simplifying your conditional formatting.  
> How
> about just using a "if Test Average is about a certain number"  
> test?  Maybe
> you are not "seeing" the correct Test Average value.
>
> --
> Richard DeShong, Athletic Study Center, UCBerkeley
>
> -----Original Message-----
> From: Peter Clifton
>
> The "Test Average" is a Summary field (Average of "Test Score").
> "Test Score" is a Calculation Field ......  Int ( Test Raw Score / .
> 25 ) & "%"
>
> "Test  Average" is stored in each student record in the external file.
>
> I tried referencing "Test Raw Score" field as well, thinking that may
> be the problem, but without success.
>
> Regards,
> Peter
>
> On 09/07/2008, at 11:13, Richard DeShong wrote:
>
>> When I create a relationship to a table in another file (an "external
>> table"), and then use conditional formatting, formula, and
>> reference fields
>> in the external table, the conditional formatting works.  So I was
>> wondering
>> if one or both fields you are trying to use are actually stored in
>> your
>> external?  Of suspicion would be your "Test Average" field.  Where
>> is that
>> number coming from?  Is it a stored field in each student record?
>>
>> --
>> Richard DeShong
>> IT Services, City of Piedmont
>> 510-642-5123 Office
>> 925-285-1088 Cell
>>
>> -----Original Message-----
>> From: Peter Clifton
>>
>> I am not using the Self function, the field being conditionally
>> formatted is from another file, through an external file reference.
>> (Works fine in that file)
>>
>> Version 9.0v3 Adv. Mac OS 10.4.11
>>
>> The formula I'm using is......... Related File:Test Score  > Related
>> File: Test Average
>>
>> The relationship between the two files is based on the Students
>> name.  All other related calcs work fine.
>>>
>>> On Jul 4, 2008, at 6:00 PM, Peter Clifton wrote:
>>>
>>>> Is it possible for conditional formatting to work on related files?
>>>>
>>>> In "File A" I have conditonally formatted a field to show if a
>>>> student's score is above average, and it works fine in that file.
>>>> When I attempt to do the same thing in a related file using the
>>>> data from "File A" it fails to work.
>>>>
>>>> Any thoughts?
>>>
>>> What is the formula, Peter?  And which precise version of FM is  
>>> this?
>>>
>>> If the formula uses the Self function, and if the field being
>>> conditionally formatted is indeed from another file (through an
>>> external file reference), then it will not work due to a bug in
>>> FM.  Don't use Self -- instead hard-code the field's name into the
>>> conditional formatting formula, and it should work.
>>>
>>> regards,
>>> Darren
>>>
>>
>>
>> _______________________________________________
>> FMPexperts mailing list
>> [hidden email]
>> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
>
>
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au


_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au