Sign Up ›
  • Megan Pietruszka
  • NEWBIE
  • 30 Points
  • Member since 2015
  • Sales Operations
  • LevelUp
  • Chatter
    Feed
  • 1
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 5
    Replies
SOLVED
10 replies

No clean data columns available for custom fields

User-added image

Please help me in fixing this error
SOLVED
10 replies

No clean data columns available for custom fields

User-added image

Please help me in fixing this error
5 replies

Needed SOQL query to check profile which has no user assigned

Hi ,

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

Please help..


Regards
2 replies

how to handle Null values in report summary

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!
 
Thanks,
Martin
2 replies

Showing Child Object activity/activity history in activity history/open activity for parent

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?


2 replies

Custom Summary Formula Average Question

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.