Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Pentaho Reporting get previous Field

  1. #1
    Join Date
    Sep 2016
    Posts
    23

    Question Pentaho Reporting get previous Field

    i am using prd 5.3
    i have a problem to get previous record
    for example :
    x | y | z | //start with 0
    1 | 1 | 2 | //0 + 2
    1 | 2 | 5 | //2 + (1 + 2)
    4 | 4 | 13| //5 + (4 + 4)
    i am using formula like this.. but i always get wrong result..
    =IF([index]=0;[totalsaldoawal]+[totalamountD]-[totalamountK];[totalamountD]-[totalamountK])
    this is my formula..
    it means
    if index = 0 // first row then [totalsaldoawal]+[totalamountD]-[totalamountK] else mustbe previous result + [totalamountD]-[totalamountK]
    i tried to find some documentation like this http://forums.pentaho.com/showthread...a-previous-row but still not help me.

    http://stackoverflow.com/questions/40105249/pentaho-reporting-get-previous-field


    Attached Images Attached Images  
    Last edited by bobby0204; 10-19-2016 at 12:07 AM.

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.