You need to sign in to do that
Don't have an account?
Ross 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
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)))
You can use one more IF condition like below :
If this helps, then kindly mark it as the best answer.
Thanks!
Thanks, is that not what I have already on the second line?
Thanks
Ross