Post Author: heme3
CA Forum: Formula
A Chicago Cop here, trying to learn all this tech stuff.
I have a C.R. that pulls data regarding all firearms recovered in the city by our officers.
There's 2 numeric fields for each cop: "Unit Assigned" and "Unit Detailed". The data is always 3-digit for both fields and looks like "001, 015, 253, 040".
So the report basically does this right now: "Inventory #12345, Smith and Wesson Revolver, Officer Smith - Unit Assigned: 001, Unit Detailed: 253"
I'm trying to make a formula for a cross-tab or chart that will sort out the officer's unit of assignment. Should be easy, but I ain't gettin' it. What I need it to do is this:
If "Unit Assigned" has a number in it, and "Unit Detailed" is null, then use the value in "Unit Assigned"
If "Unit Assigned" has a number in it, and "Unit Detailed" has a number in it, then use the value in "Unit Detailed"
(the "Unit Assigned" field is never null)
:o)
George
george.hemesath@chicagoplice.org