AnsweredAssumed Answered

Help with a calculation

Question asked by Terri on May 5, 2010
Latest reply on May 5, 2010 by comment_1

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

 

 

 

Outcomes