Jump to content
Sign in to follow this  
curious99

# fields to add up based on data in text field

Recommended Posts

Hi

I have 4 number fields "cost of repair 1, cost of repair2 , cost of repair 3 and cost of repair 4". I also have 4 text fields "type of repair cost 1, type of repair cost 2, type of repair cost 3, type of repair cost 4" I want to add the values of all the cost of repair for which there is a value "other accessories" entered into any of the text fields named above. Is it possible to do these conditionnal additions in filemaker?

Share this post


Link to post
Share on other sites

Hi LUC.ROBITAILLE,

Case(type of repair cost 1 = "other accessories" , cost of repair 1) +

Case(type of repair cost 2 = "other accessories" , cost of repair 2) +

Case(type of repair cost 3 = "other accessories" , cost of repair 3)+

Case(type of repair cost 4 = "other accessories" , cost of repair 4)

See if this does what you want.

HTH

Lee

smile.gif

Share this post


Link to post
Share on other sites

Thanks, it works! I had to add "0" ,in the syntax.

Case(type of repair cost 1 = "other accessories" , "0" ,cost of repair 1) +

Case(type of repair cost 2 = "other accessories" , "0" ,cost of repair 2) +

Case(type of repair cost 3 = "other accessories" , "0" ,cost of repair 3)+

Case(type of repair cost 4 = "other accessories" , "0" ,cost of repair 4)

If I may refine my problem, I find it rather tedious to do so for not the 4 number fieds but the 26 I have...not to mention that there are other choices that "other accessories" to add up but also "remote starters" and 3 other choices...is there any other ways of doing it that you might know of?

thanks again

;-)

Luc

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.