Author Topic: Summary on Custom field  (Read 3422 times)

Offline jcaserti

  • Associate
  • **
  • Join Date: Nov 2012
  • Posts: 2
  • Forum Citizenship: +0/-0
Summary on Custom field
« on: 15 Nov 2012 09:47:51 am »
I have a report with several columns that have a summary.  My custom column that was created in Framework Manager is an "All Other" column.  If any of the previous columns do not have a value then the All column = 'Y'.  When I apply the summary to this column, the count displays as a total row count, not just the 'Y'.  The other fields count as they should.  I have attached a copy of the report which I downloaded in excel format.  The 'All Other' column should show a summary count of 16, but it has the same count as the ID  count of 67.  Any ideas why this is happening and how I can resolve it?

Offline Bark

  • Community Leader
  • *****
  • Join Date: Nov 2012
  • Posts: 79
  • Forum Citizenship: +7/-0
Re: Summary on Custom field
« Reply #1 on: 16 Nov 2012 05:22:28 am »
What's the expression for "All other"?

My guess is that you are populating the column for every value, even if you are doing so with an empty string (''). That is why the count is returning the number of rows, because all of them have something. Change FM to populate Y or NULL instead of Y or ''.

Regards,

Bark

Offline jcaserti

  • Associate
  • **
  • Join Date: Nov 2012
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: Summary on Custom field
« Reply #2 on: 16 Nov 2012 01:11:43 pm »
Thanks, Bark...that makes sense.  I will make the change.  I was using 'Y' or ''. 

 


       
Twittear