2 Replies Latest reply on Mar 13, 2012 1:18 PM by Terri

    Count Text Length in Calculation

    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?