Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: sum of values

  1. #1
    Join Date
    Oct 2012
    Posts
    116

    Default sum of values

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

    Example.
    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?
    Thanks

  2. #2
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    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
    Posts
    116

    Default

    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.