0 Replies Latest reply on Jan 14, 2014 1:42 PM by Matthew Petrich

    Show totals from one date and another date determined by a parameter

    Matthew Petrich

      Hello everyone,

      I have some financial data.  Very simple, I have a posting date, a total, and a document type.

      I have two different document types, ZP and ZR.

      The logic works like this.

      Example; I have one ZR record on 5/1/13 and that total is $1000.  I have multiple ZP records on 5/2/13 and they total $1000.

      In theory, when summing the ZP records from the following day of the ZR record, both totals should match.

      In reality, I am seeing that the totals can match in 1 day, 2 days, 3 days, etc.  It's not always a one day spread.

      I am trying to show this in a visual.

      I was trying to do something like this.

      This would be my field listing;

      Post Date, Post Date + Day spread as defined by a parameter, ZR record total for Post Date, ZP record total for Post Date + Spread.

      That's what I am trying to do but I can't get it to work.  Can I not get all of this information into one line of a view?

      Any ideas?

      Thanks a million for the help.