Jump to content

Calcuation based on portal value


GameTapper
 Share

This topic is 5599 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am trying to write a calculation for a field that will compare a fixed date to a list of dates within a portal. If any of the portal lines has the fixed date then the script should return a value of "Yes." Within the portal the fixed date will never occur more than once per record.

This is what I've come up with, but it is only returning yes if there is only one entry in the portal and the entry matches the fixed date:

If( MultiplayerInServiceDate = Dates_Titles::AirDate;"Yes";"")

where MultiplayerInServiceDate is fixed and Dates_Titles::AirDate is the field within the portal.

The actual portal is in a layout that is based on the Titles table, not the Dates table.

I'm using FMP 8.03 on WinXP.

Thanks!

G$

Link to comment
Share on other sites

This topic is 5599 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.