function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Ross SutherlandRoss Sutherland 

replace negative with 0

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)))

 
PriyaPriya (Salesforce Developers) 
Hey Ross,

You can use one more IF condition like below : 
IF(calculatedValue < 0, 0, calcualtedValue)

If this helps, then kindly mark it as the best answer.

Thanks!
Ross SutherlandRoss Sutherland
Hello Priya,

Thanks, is that not what I have already on the second line?
Thanks
Ross