Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: calculated field

  1. #1
    Join Date
    Jan 2006
    Posts
    313

    Default calculated field

    In the report i need a calculated field. The formula is easy, TableA.fieldA * TableB.fieldB. Both are in the business view defined in Metadata.

    Can i calculate this field from the Adhoc reporting UI or do i need to change this manually?

  2. #2
    Join Date
    Nov 2006
    Posts
    135

    Default Cannot calculate product of 2 DB fields in Adhoc Reporting

    You cannot calculate the product of 2 DB fields in Adhoc Reporting.

    I would suggest taking a look at your metadata model, and seeing if you can specify this calculation in the metadata model.
    Last edited by sbarkdull; 04-14-2008 at 08:41 AM.

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.