• Ross Sutherland
  • NEWBIE
  • 15 Points
  • Member since 2021

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 4
    Questions
  • 7
    Replies
Hello,

My utilisation formula returns negative values but I would like them to be displayed as 0 instead, any ideas why it is not working?

Thanks
Ross
IF(fta__Absence_Day_Record__c.Utilisation__c:SUM= 0.00, 1,
IF(fta__Absence_Day_Record__c.Utilisation__c:SUM <0 ,0,
(253* fHCM2__Employment__c.fHCM2__FTE__c:SUM - fta__Absence_Day_Record__c.fta__Duration__c:SUM)/(253*fHCM2__Employment__c.fHCM2__FTE__c:SUM)))

 

Hello,

Trying to create a row level formula that looks to see if any columns has a blank so I have something like, 

IF(ISBlank(fHCM2__Team_Member__c.fHCM2__Birth_Date__c),"Blank","Not Blank")   which is fine.

But I want to add OR so I want to include OR IF ,
fHCM2__Team_Member__c.fHCM2__Manager__c is blank
OR IF, FK_fHCM2__Employment__c.UDFEmployment_Detail__c is blank


FK_fHCM2__Employment__c.UDFEmployment_Detail__c   is a picklist field so not sure how to add that in also.

Any ideas?

Thank

Ross
 

Hi I am looking for a easy way to print or export a large Field Dependency matrix in excel. I am new to saleforce please guide me with complete details.