5 Replies Latest reply on Jul 24, 2018 10:03 AM by Jenny Ng

    Calculation using filtered value

    Jenny Ng

      I have two separate sets of data that are not related, BUILDING and MODEL. I want to use the filtered value in MODEL (Cost/Size) to calculate the Operating Cost in BUILDING (Actual GSM * Cost/Size), listing all Cost Types. How do I do that? Please see workbook attached. I'm using version 10.5.

       

      Thank you!

      Jenny