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

jduncan
 Share

Recommended Posts

Hello All,

 

I'm trying to calculate defects recorded in a portal. I have a product testing layout that includes a portal that records defects such as severity cracking (none, minor, moderate, severe) and bruising (none, minor, moderate, severe) by sample number. I used a portal because the number of samples can vary, depending on the testing. Is there an easy way calculate the number of samples that have no cracking, the number that have minor cracking, the number that have moderate cracking and the number that have severe cracking?

 

I'm sure that there is but the answer is escaping me near the end of a long day :)

Link to comment
Share on other sites

Create a new TO of your Defects table and relate it to a global DefectType field in your main table.

 

Products::DefectType----- = -----NewDefectsTO::defect

 

Create a script that sets DefectType to the value you want to count, and then sets a field in your main table to Count(NewDefectsTO::defect). Then set DefectType to the next category and repeat as necessary.

 

Since this is a many-to-many relationship, you really need to have a join table between Products and Defects in which each record is one defect in one product.

Edited by doughemi
Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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.

 Share



×
×
  • Create New...

Important Information

Terms of Use