You need to sign in to do that
Don't have an account?
RAJNag
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
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
Still not working.
thanks
Raj
Still not working but no syntax error i dont know what i did mistake?
Regards
Raj.
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"
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
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
try with below it will work
Let m eknow if it helps !
Thanks
Manoj