I am trying to remove data from one field based on data in another. I have many properties [Unit Type] the string needs to Find and replace the [Deposit Held] for each: Having an issue with if statement; can the group help me with where I am missing the proper statement. Or alternate resolution. I attached screen shot and data. The issue is when I fill down resident name; I am capturing the total of all deposits held for that property also for the last resident. Highlighted for visual understanding in screen shot.
IF [Unit Type] IN ("11th & Spruce Total:") then [Deposit Held] ="0" else 0 endif
IF [Unit Type] IN ("11th & Spruce Total:",
"250 High Total:",
"600 Goodale Total:",
"80 On The Commons Total:",
"801 Polaris Total:",
"Baxter Park Total:",
"Bracken House Total:",
"Buckstone Flats Total:",
"Burrough's Mill Total:",
"Devonshire Total:",
"Dixon House Total:",
"Edison at Gordon Square Total:",
"Emerson Park Total:",
"Gateway Lakes Total:",
"Gateway Lofts Centerville Total:",
"Gateway Lofts Columbus Total:",
"Gateway Lofts Lansing Total:",
"Gateway Lofts Lexington Total:",
"Graham Park at The Highlands Total:",
"Harper House at The Highlands Total:",
"Heritage Green Total:",
"Lane Lofts Total:",
"Lofts at Norton Crossing Total:",
"Lumina Total:",
"Luxe 88 Total:",
"Luxe at The Highlands Total:",
"Madison House Total:",
"Marina Lofts Total:",
"Marine Club Total:",
"Market & Main Total:",
"Minnetonka Station Total:",
"Mulberry Lofts Total:",
"North Shore Flats Total:",
"Packard Building Total:",
"Park's Edge at Shelby Farms Total:",
"Pennbrook Station Total:",
"Polo Run Apartment Homes Total:",
"Pulliam Square Total:",
"Rize at Opus Park Total:",
"Spectra Total:",
"Spring House at Brandywine Total:",
"Station 324 Total:",
"Steel House Total:",
"Stillwell at Avery Centre Total:",
"Stillwell Jerome Total:",
"Stilwell at Wellen Park Total:",
"Sugar Run Total:",
"The Aubrey Total:",
"The Baylor Total:",
"The Darby at Briarcliff Total:",
"The Flats at Douglas Total:",
"The Gramercy Total:",
"The Jacqueline Total:",
"The Kingston Total:",
"The Monarch Total:",
"The Normandy Total:",
"Preserve at Forest Creek Total:",
"The Reserve of Sugarcreek Total:",
"The Stratton Total:",
"The Thomas Total:",
"View on Grant Total:",
"Tribeca Total:",
"Willis Avondale Estates Total:") then [Deposit Held]= "0" else 0 endif
