Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Calculator Input String Error

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Aug 2017

    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...

    ...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!


  2. #2
    Join Date
    Apr 2008


    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.