AnsweredAssumed Answered

Count Text Length in Calculation

Question asked by Terri on Mar 13, 2012
Latest reply on Mar 13, 2012 by Terri

Title

Count Text Length in Calculation

Post

Hi

Working with FMPro 11 Advanced on a Mac.

Using a case calculation and I need to have part of it identify the first two characters in the book name then calculate the page count times a certain number. See current calculation 

(Round (Case (Book Name Canceled = "canceled"; ""; Division = "INTL_Japan"; PageCount_Body * 330; LeftValues ( Book Name ; 2 ) = "DE" or LeftValues ( Book Name ; 2 ) = "AT"; PageCount_Body * 243); 2))

Calculation isn't returning anything right now.

Any ideas?

Outcomes