6 réponses
Hi Nikki,
What kind of field relationship is there between Lease Info & Account (i.e., just a standard lookup relationship or a master-detail where every Lease Info record must be associated with an Account)?
If it's a master-detail relationship, then you could do Roll-Up Summaries on the Account record for each building (i.e., count the # of Lease Records where Building A, Building B, etcetera is the picklist value) & then a formula field to calculate the # available (e.g., 100 - aforementioined Roll-Up Summary)
Right now, you should be able to create a Summary or Matrix report to show the # available...basically group the report by the picklist value specifying the building & then create a custom formula of 100 - Record Count
