How to trigger a check mark symbol when a result is not true?

[buckbuck]

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

[doughemi]

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

[buckbuck]

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

[LaRetta]

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?

[buckbuck]

LaRetta

Here is the file.

Thanks

[LaRetta]

No file attached.  Please try again.  :-)

[buckbuck]

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

LdSample.fp7.zip

[LaRetta]

Try this.  

LdSampleMOD.fp7.zip

[buckbuck]

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

[LaRetta]

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.