If Then Statements

[sslattery17]

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

[Bobbyt23]

Did you change the;

then [Deposit Held]= "0" else 0 endif

To

then NULL() else 0 endif

Or the value you want it to be if it is not 0 for ones not in that group.

[sslattery17]

@Bobbyt23

If i change then too NULL() else 0 endif from [Deposit Held]="0" else 0 endif , the entire column of deposits held are changed to zero and that is not what I want; I just want the one deposit total associated with each property total: listed.

[Bobbyt23 · Accepted solution]

Sorry for the misunderstanding I thought you were wanting to change that field. In that case you do want a filter to only bring back the rows in the list?

Just put this part  in a filter tool and it will show you all rows where the Unit Type is in that list, all others will be removed.

[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:") 

[sslattery17]

@Bobbyt23 Thank you.  That resolved issue.  I was trying to make it to complicated.