Hi All,
I'm looking for the best way to add numeric values (quantities) from a Record format field value.
I have a "garbage station" symbol which depicts several garbage cans. The attached record format has fields for "Compost", Recycling" and "Garbage" and would like to specify the number of bins in that particular symbol for each type. I then need to put it into a report, where the bin type is in column A, and the total number of bins is Summed in Column B from all symbols placed.
Right now I can only get it to work with each bin field getting it's own column, so essentially I need to swap the rows and columns, or find a better way to
Any help would be appreciated!
Thanks,
Nic