6 Replies Latest reply on Sep 12, 2016 8:41 AM by Matthew McHale

    How do I aggregate logical statement outside of the view?

    Matthew McHale

      Hi all,

       

      I'm really stumped here trying to calculate a count based on dates and a field not in the view.  I apologize if i'm not explaining this clearly.  I assume this should be a simple question.  Below are the formulas and a view of the data:

       

      Issues Pre Purchase: IF ATTR([Repair date]) < ATTR([Warranty start]) OR ISNULL(ATTR([Warranty start])) AND [Count of Issue ID] > 0 THEN [Count of Issue ID] END

      Issues Post Purchase: IF ATTR([Repair date]) >= ATTR([Warranty start]) THEN [Count of Issue ID] END

       

       

      Issue ID Displayed.PNG

       

      I'm trying to get the view below without having the repair date, issue ID, or count of the issue ID in the view from above.  I'd like to total the count for pre and post and display it without the other data in the view.  It looks like since the issue ID isn't in the view it won't display the count If I have a VIN with more then one issue with dates that fall into the different categories it only shows the one.

       

      No Issue ID.PNG

       

      Thanks,

       

      Matt