11 Replies Latest reply on May 5, 2010 2:04 PM by comment_1

    Help with a calculation

    Terri

      Title

      Help with a calculation

      Post

      FMP 11 system.

       

      I have a calculation field I need help with. This is currently how it reads:

       

      Case ( PageNumberA = "s" ; "" ; PageNumberA = Catalogs::Page Count/2; "Center of Book")

       

      Basically I want it to read PageNumberA. If it has an S in it then it should leave this field blank. If the page number is equal to the Page Count divided by 2, insert "Center of Book".

       

      My page count looks like this ( Page Count = 6):

      001

      002

      003

      004

      005

      006

      S01

      S02

      S03

      S04

      S05

      S06

       

      It  is currently inserting this field in the record for page 003 AND S03 (like it doesn't see that there is an S in the page number).

       

      What am I doing wrong?

       

      Thanks,

      Terri