• Megan Pietruszka
  • 30 Points
  • Member since 2015
  • Sales Operations
  • LevelUp

  • Chatter
  • 1
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
  • 5
Hi ,

I needed a query which can retrieve profile names which has no user assigned to it.

Please help..

Greetings everyone,
I have an object that contains student test data for a given year.  Each student takes maybe a dozen test per year.
The fields are StudentID, Year, Test1, Test2, Test3... .
I created a report that shows the averages for each test for all students in a given school/district (loved how easy that step was).
The problem I am facing is that students will be missing some of the tests, so some of the values will be NULL.
It appears that on reports Salesforce treats NULLs same as zeros, which of course messes up the calculation of an average score, which in the case of results like {20, Null, 10} is calculated as 10 instead of 15.  I know that XL and Access do not include NULLs in averages, and I am at a loss on how to work around this in Salesforce.
Does anybody know how I can create a 'Average' report summary field that excludes NULL values?
If someone has a solution to this I'd be jumping up and down!
For the standard account object, if there is a child object defined, any activity/activity history for a child record shows up in the Account's activity/activity history.

I do not see this happen for a custom object parent and a custom object child...

Anyway to make it happen?

I am trying to generate a report that will average the number of days that an opportunity spends in certain stages of our sales process.  I have fields in each opportunity that calculate the number of days per stage, but the problem that I am running into when generating the report is that many of the opportunities have not reached the final stages.  When I average that column, the report totals the number of days for all opportunities and then divides by the total number of opportunities.  I need it to just divide by the number of opportunities for which there is a value present.  For example, if only two opportunities have reached the final stage and have values of 10 and 14, but there are 8 total opportunities in the report, the report returns an average of  3 instead of 12.  I currently have the fields setup so that they treat blank values as blanks.  Does anyone know if this possible, and if so, how would I do this?  Thanks.