Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Running Count with condition

  1. #1

    Default Running Count with condition

    I am trying to setup a running count that will only increment on a certain condition. Example: I have a set of data coming in and if Name = "John" I want the counter to increment by one when the name is "John". I tried using the IF statement in the formula but I can't get it to do a running count.

    Thanks for the help.

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

    First make a field with formula =if([Name]="John";1;0) Then with that field you make a function : Sum (Running) with the result of the formula

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.