I would appreciate any suggestions to help my formula to work.
I am trying sum acres of property acquired by company under category 'TR' (for transit) then subtract property we disposed of in that same category; however when I add in the category for disposed in the formula, it doesn't work. The second formula works when I remove the 2nd category in the formula, but then it subtracts disposed property for all categories.
=DSum("[Fee SqFt]","[UTA Property Database]","[Category]='TR'")/43560-DSum("[Disp SqFt]","[UTA Property Database]",”[Category]=’TR’”)/43560 >Doesn’t work
=DSum("[Fee SqFt]","[UTA Property Database]","[Category]='TR'")/43560-DSum("[Disp SqFt]","[UTA Property Database]")/43560 >Works, but doesn't give right answer because it subtracts disposed for all categories.