Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Time Based Formulae

  1. #1
    Join Date
    Apr 2008
    Posts
    4,690

    Default Time Based Formulae

    Hi All....

    Strange requirements ... AGAIN.

    I have a request to build a report which will pull the sum of all minutes from a table, grouped by an ID and date, with parameters, and total the time

    Is there a way that I can do some Report Math and Report Formats, so that I can get HH:mm from the sum(Minutes)

    In Excel, the formula would be =FIELD/(60*24) and format as HH:mm...

    I just want to know how to do that in PRD / BIServer...

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

    Default

    =DATE([FIELD]/(60*24))

    You get back a java.util.Date and how you format it is up to you and your number-field.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

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.