Help with a calculation
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):
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?