AnsweredAssumed Answered

Comparing Counts

Question asked by lindseym on Jan 5, 2017
Latest reply on Jan 6, 2017 by lindseym

I am trying to figure out the best way to compare Initial Counts vs Actual Counts

 

The initial counts are not located in the database that gives me my CSV to import into FMP.

 

I thought I would have to import them manually, which isn't ideal but totally acceptable.

 

Here is what I want it to look like (although when I type an initial QTY all the QTY changes.

 

Screen Shot 2017-01-05 at 4.56.18 PM.png

 

and in layout mode ( I have it twice based on how it is sorted)

 

Screen Shot 2017-01-05 at 4.56.31 PM.png

 

 

Is there a better way to do this? Actual QTY will continue to be updated and new sign types may be added. It wouldn't be ideal, but I could manually adjust the initial counts if a new sign type makes things go out of order for the drawing sheets.

 

 

Thank you!

 

-L

Outcomes