Skip to main content
Topics#Data ManagementPregunta de Matthew Carpenter
Matthew Carpenter (Sarma) preguntó en #Data Management
19 ago 2014, 21:14

How do I use IF statements in formula fields to leave fields blank?

I have a few custom fields with sales amounts and a formula field for calculating variance between last month's and this month's number. This works well except when I have no data to input or the prior month was $0 for a particular account. Of course since this divides by 0 I get  #.Error! in the formula field. I'm sure I could use some sort of IF statement for the prior month field to just leave the formula field blank if it's unpopulated or =0 but I'm not sure of the syntax to use in this instance. Any help would be appriciated.
7 respuestas
  1. Steve Molis (You Owe Me a Beer, Inc.)
    19 ago 2014, 21:40
    You formula would be: 

     

    IF(
    OR(Prior_Month__c = 0, ISBLANK(Prior_Month__c )), NULL,
    ( Current_Month__c  -  Prior_Month__c ) /  Prior_Month__c)
Escribir una respuesta...
0/9000