Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Calculator Input String Error

  1. #1
    Join Date
    Aug 2017
    Posts
    1

    Question Calculator Input String Error

    What is the correct syntax for counting the number of values in an Excel column if the value is not null?

    I tried...
    counta('Summary'!B28:B88)

    ...but got this error:
    Couldn't parse Integer field [NUM_GROUPS] with value [counta('Summary'!B28:B88)] --> java.lang.NumberFormatException: For input string: "counta('Summary'!B28:B88)"

    Thanks for your help!

    Sue

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Which tool are you using?

    PDI / Spoon or PRD?
    Your title sounds like PDI, but some of the detail sounds like PRD.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.