function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
RAJNagRAJNag 

Formula not updated

Hi 
I am having four fields like  
nagaraju__Num1__c
nagaraju__Num2__c

nagaraju__Number1__c
nagaraju__Number2__c
whenever these two fields nagaraju__Num1__c,nagaraju__Num2__c equal to null remaing two fields are sum and update the formula field .

I wrote this condition but in that formula true conditon not working only false conditon working let me know the what i mistake plz 

IF((nagaraju__Num1__c == null && nagaraju__Num2__c == null),nagaraju__Number1__c + nagaraju__Number2__c,nagaraju__Num1__c + nagaraju__Num2__c)

thanks 
Raj
Abhi_TripathiAbhi_Tripathi
Try this
IF( AND( ISBLANK(nagaraju__Num1__c), ISBLANK(nagaraju__Num2__c)), nagaraju__Number1__c + nagaraju__Number2__c,nagaraju__Num1__c + nagaraju__Num2__c)

 
RAJNagRAJNag
Hi Abhi 

Still not working.


thanks 
Raj
Abhi_TripathiAbhi_Tripathi
Try this I think this will work
IF( AND( ISBLANK(nagaraju__Num1__c), ISBLANK(nagaraju__Num2__c)), 
   IF( 
      AND( NOT(ISBLANK(nagaraju__Number1__c)) , NOT(ISBLANK( nagaraju__Number2__c)) ) ,
           nagaraju__Number1__c + nagaraju__Number2__c, 0
      ), 
   nagaraju__Num1__c + nagaraju__Num2__c)

 
RAJNagRAJNag
Hi Abhi,

Still not working but no syntax error i dont know what i did mistake?

Regards
Raj.
Ashwin Kumar SrinivasanAshwin Kumar Srinivasan
Please try this.

IF(( ISBLANK(nagaraju__Num1__c) && ISBLANK(nagaraju__Num2__c)), nagaraju__Number1__c+nagaraju__Number2__c, BLANKVALUE(nagaraju__Num1__c, 0) + BLANKVALUE(nagaraju__Num2__c, 0))


Also when you edit the formula field, goto bottom of page to section Blank Field Handling and set "Treat blank fields as blanks"
 
ManojjenaManojjena
Hi Rajnag,

I have a small query here ,please clarify for which I may help  you .

if both will null then you want to update the formula with summation of next two fields ,
if one of then will not null then what your formula will return .
If both will  not null then what your formula should return ?

Please clarify .

Thanks
Manoj
RAJNagRAJNag
Hi Monoj
if both will null then you want to update the formula with summation of next two fields ,
if one of then will not null then what your formula will return .

These two conditions



thanks
Raj
 
ManojjenaManojjena
Hi Rajnag,

try with below it will work 
 
IF( AND( ISBLANK(nagaraju__Num1__c), ISBLANK(nagaraju__Num2__c)), (nagaraju__Number1__c + nagaraju__Number2__c),0)

Let m eknow if it helps !
Thanks 
Manoj