I'm trying to remove the subtract symble from a formula field. This formula field is based on a two fields. one is date field value anthoer one is Text filed value. Is that a possibility?
TEXT((TODAY() - (DATEVALUE(CreatedDate)- VALUE(Daysonrecord__c))))
TODAY()=10/10/2017 CreatedDate=6/10/017 Daysonrecord__c=19 ==> (10-(6-19))=(10-(-13))=23
Actuvally Excpecting answer is (10-(6-19)) = (10-(-13)) = 3.
how to remove substract symbol before '-13'. How can i achieve my expected answer 3.