Trying to do an inventory calculation in my customer header. Right now I have this in the customer header - =Count(IIf([Request]="Install",1)) one for installs and one for removals and =[Remove]-[Install]. This is reading each customers totals. I am having trouble figuring out how to incorporate a unique starting number for each customer to come up with an "on hand" total. example have 10 panels install 5, remove 4, have 9 on hand. Been at a bypass for a while.
Thanks
lj