Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Chad RitchieChad Ritchie 

Adding Text to Percent Formula Field

Hey guys,

So I'm trying to create a field where if record is "A" than the field will be a calculation (Total/Estimate), therefore it's a percent field type. But, if the record is "B", meaning it doesn't have a total or an estimate, I'd like for the field to just show "N/A". Is there anyway this is possible to have text in a formula field of percent type. The reason being that I'd hate to have an error or blank field for all type "B"s. Thanks!!!
Gobinath AGobinath A
Hi Chad,

Please try the below and let me know, if it not works.
  
IF(
OR(
Total == '',
Estimate =='',
  ),
"N/A",
Total/Estimate
)


Please contact us, if you need anyother support, 
http://www.merfantz.com/contact

Thanks