+ Start a Discussion
sfdc2705sfdc2705 

formula help for number field

Hi All,

I want a formula for the below scenario.

If the value of field 'A' is 'One' , then i want the value of field 'B' (number field) 'B+1'.

It may be simple but mind is not working today..

Thanks
 
Amit Chaudhary 8Amit Chaudhary 8

please try like below

CASE( Field_Name__C
"One",B =B+1,
"Two",B=B+2,
0)

Let us know if this will help you
 
Karthi XaviKarthi Xavi
You want to do it with a Field update or with a Formula field?
sfdc2705sfdc2705
Hi Karthikeyan,
Thanks for looking into this
I want to with a formula field if it fits my scenario.

Thanks