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

Newbie needs help - lots of it!


mrbob
 Share

Recommended Posts

Hi all,

 

I am very new to database and completely stuck when it comes to calcs and scripts! I need about 12 calcs to complete a database I've started and wondered if you guys could help? I'll start with 1 and see how it goes ....

 

How do I do this example? - Field '2' = Field '1' +20 if Field '3' = Text 'ABC', or + 60 if Field '3' = Text 'XYZ'

 

Thanks in advance.

 

Bob.

Link to comment
Share on other sites

Field '2' = Field '1' +20 if Field '3' = Text 'ABC', or + 60 if Field '3' = Text 'XYZ'

 

You've almost got it already. The syntax is only slightly different from ordinary English:

 

Field 1 + Case(Field 3="ABC", 20, Field 3="XYZ", 60)

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use