Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Calculation


Jim G

Recommended Posts

I have two fields InsCoName and GAName. I need the result to be different when the GAName changes. I have been using an If statement but just can't get it right. Example:

 

If InsCoName=AIG & GAName=WIIN then CALC= My Code for WIIN or "Y1417"

 

If InsCoName=AIG & GAName=TSG then CALC=My Code for TSG or "99890"

 

If anyone can help I am very appreciative thanks Jim G

Link to comment
Share on other sites

Jim,

 

instead of

 

If InsCoName=AIG & GAName=WIIN then CALC= My Code for WIIN or "Y1417"

If InsCoName=AIG & GAName=TSG then CALC=My Code for TSG or "99890"

 

you could try

 

Case( InsCoName="AIG" and GAName="WIIN" ,"Y1417",

InsCoName="AIG" and GAName="TSG" , "99890", "")

 

Result of the calculation should be text

 

This will basically do the following

 

If InsCoName is AIG AND GAName is WIIN then the result is Y1417

 

OR

 

If InsCoName is AIG AND GAName is TSG then the result is 99890

 

HTH

Link to comment
Share on other sites



×
×
  • Create New...

Important Information

Terms of Use