Jump to content

Softgoods worksheet couting


Recommended Posts

I'll try to explain what I am looking to do.  I am trying to create a worksheet that will count my pipe and drape cross pipe, uprights, and drape counts, which after a bit of googling I can do on a basic level.

 

However, I have two sizes of pipe and drape, 12' and 16' high uprights.  I also have multiple types of drape, different colours of supervel and velour.  I am using the material, material colour, and note records in the Softgoods PIO Object Info to track the info.  The note record has either a 12' or 16' value.  Where I am running in to an issue is when I try to limit the database row in the worksheet to only target subdivisions.  Ex, I only want a drape panel count of 12' Black Velour.

 

But if I try to set multiple criteria I do not get the result I want.  If I try the following criteria on the database row:

Record>Soft Goods>is present

Field Value>Note>=12'

Field Value>Material Type>=Velour

Field Value>Material Color>=Black

instead of looking at only the objects that are all three, it returns all of the 12', all of the velour, and all of the Black pipe and drape.  Am I missing something in how Criteria works?  I'd like to be able to have multiple criteria that allows me to really narrow down on a selection.

 

Thanks :)

Link to comment

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.   Restore formatting

  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.

×
×
  • Create New...