• Philip Gulan
  • NEWBIE
  • 35 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 2
    Likes Received
  • 0
    Likes Given
  • 8
    Questions
  • 8
    Replies
I have written a short formula to calculate the average value of multiple currency fields, so that if there is a blank value, it shouldn't be calculated.
Logically everything seems fine, but it is not recognizing the the blank fields

Any help is apperciated.

(ValueA__c +  ValueB__c + ValueC__c ) /
(
IF(ISBLANK(ValueA__c), 0, 1) +
IF(ISBLANK(ValueB__c), 0, 1) +
IF(ISBLANK(ValueC__c), 0, 1)
)

The problem is that wether the fileds are blank or filled the values are divided by 3 which it should be divided only based on the filled fields
Hi, 

I want to write Apex code to send mass email to a selected contact list - List<Contact> - and select an email template.
Any help is apperciated.

Thanks
I need to create a formula field to get the date from the Creation Date and convert it to Julian Date. any help is apperciated
Trying to find this setting in salesforce and it is not populating...please help
Hi All,

    We have the data coming from external application to salesforce where the dates are stored in Julian format in 6 digits in external party application. . Can you please help me to convert this to salesforce date format through formula or workflow rule or Apex code

For ex : Julian date 115054 need to convert to salesforce date format 2/23/2011