Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Conversion of 3 to 7 - 'If' function


mjrogers50

Recommended Posts

In Filemaker 3, Field_name=If(Value1>Value2,"Below","Above")

displayed "Below" if false and "Above" if true, plus returned a numeric value of 1 for true which could be counted. (How many times value1 was greater than value2)

 

Converting the database to Filemaker 7, I found the following:

 

Field_name=If(GetAsNumber(Value1)>GetAsNumber(Value2);"Below";"Above")

displayed "Below" if false and "Above" if true but no numeric value which could be counted.

 

Changing this to:-

If(GetAsNumber(Value1)>GetAsNumber(Value2);0;1)

restored the counting but of course didn't display "Below" or "Above".

 

Any suggestions how the result obtained in version 3 might be achieved in Filemaker 7 would be greatly appreciated.

Link to comment
Share on other sites

If you just want it to display as Below or Above, go to the number formatting options in the layouts where it is displayed and set the boolean display to Above for 1 and Below for non-1.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...

Important Information

Terms of Use