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.
and in layout mode ( I have it twice based on how it is sorted)
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.