Using IsEmpty to return the correct results

[river bend]

I posted a sample file to explain what i'm trying to do. In the employee record i want the field flag to have a value of "on" if any of the related records does not have a value in the stop field. This needs to work even if the portal is not on the layout. thanks

trying to figure out how to post the file

Untitled.fmp12.zip

[Gabriel Khaselev]

So you were using LineItem:lineItemFlag instead of the stop field in the calculation. set the flag field calculation to:

 

If ( IsEmpty(LineItems::stop) ; "Off" ; "On" )

 

or something like that, if you dont want the Off.

 

 

Good Luck with your solution!

Gabe

[Lee Smith]

I think I would put the flag in the related data portal, I also used Conditional Formatting so that it would stand out. You don't need a default in a case statement, it will default to empty.

riverbend.fmp12.zip

Edited June 18, 2013 by Lee Smith
left out the word portal

[LaRetta]

IF you need the LineItems flag calculation which produces the "on" for other things then you can keep it but you do not need it at all to achieve what you wish.   In Employees,  your flag calculation (result is text) could be:

 

Case ( Count ( LineItems::keyID ) > Count ( LineItems::stop ) ; "On" )

[river bend]

Yes, that works. Thanks

 

IF you need the LineItems flag calculation which produces the "on" for other things then you can keep it but you do not need it at all to achieve what you wish.   In Employees,  your flag calculation (result is text) could be:

 

Case ( Count ( LineItems::keyID ) > Count ( LineItems::stop ) ; "On" )

Yes, that works great. Thanks