+ Start a Discussion
AAIAAI 

how to create formula to populate the value from field A to field B in a report?

Hi,

I need to create a formula to populate the value from a field A to field B when field A value is null.
I am trying with this formula in the report:

IF(
ISBLANK (field A) , NULL,
field A = field B)
The fields are numbers
Any help wou be great.

Thanks,
Amaya
Karthik Nallajalla 10Karthik Nallajalla 10
Try the following syntax in field B:

IF(ISBLANK (field_A__c) , NULL, field_A__c)
kamala swarnalathakamala swarnalatha
Try this one,

IF( ISNULL( FieldA__c ) ,  FieldA__c , NULL)

Kamala
Sweet Potato Tec