I am trying to create a scenario whereby a check symbol (Container field)  appears when the result of a calculation in a subsummary part is true.

I have the check symbol field: g highlight, container, global

I have a calculation field; container,

 

The calculation is:

 

when

 x - y ≠ 0; g highlight; ""

 

(x & y are summary fileds)

 

I have inserted this field into the subsummary line.

 

It does not function as hoped? Is it because this calculation is in a subsummary part? Are thoughts? Thanks

There is no "When" command in FileMaker.  Try If(x - y ≠ 0; g highlight; "")

Yes of course, no when. Anyway this does not work if or case. Could the issue be the subsummary part?

If you are wanting the result in a calculation then you probably need to use GetSummary ( summaryField ; breakpoint ) but we really don't have enough information.  

 

Can you create a simple file showing the important fields/relationship, zip, and post the file?

LaRetta

Here is the file.

Thanks

No file attached.  Please try again.  :-)

Here it is. I think it did not upload previously.

LdSample.fp7.zip

Try this.  

LdSampleMOD.fp7.zip

LaRetta

Thank you for the solution. I do not quite understand how your calculation distinguishes or differentiates the ≠ 0 qualifier to produce the desired container field. Can you explain this to me?

 

If (
GetSummary ( GJEntryDRL_Sum ; Date ) - GetSummary ( GJEntryCRL_Sum ; Date ) ;

g GJEntryZeroSum Yes ; g GJEntryZeroSum No
)

 

Regards

Subtracting CRL_Sum from DRI_Sum produces a number. Any number at all returned ( plus or minus, other than zero ) returns boolean true.

 

So this says ... if there is any number returned other than zero, it is true so show container YES otherwise ( so if it is zero ) show container NO.