Count Text Length in Calculation
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.