Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: sum of values

  1. #1
    Join Date
    Oct 2012

    Default sum of values

    I would like to use sum function on my own values.
    I am loading data from database to my report, then I am using specific number field with formula expression where I compare loaded data with my own formula.

    number from db formula my number field (result)
    100 if[number]>150;500;0 0
    200 if[number]>150;500;0 500
    300 if[number]>150;500;0 500

    I want do sum of results.
    Is it possible?

  2. #2
    Join Date
    Mar 2003


    Any formula or calculation you do on a report-element (number-field etc) will only be used when printing this particular field. You wont be able to reference this calculation elsewhere. To do that use a named Formula-Expression (via Data->Add Expression/Function) so that the result of the formula shows up as new data. Then you can add a sum-function that references this new named formula expression.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  3. #3
    Join Date
    Oct 2012


    Fantastic! Thats exactly what i wanted

    Thank you

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.